unable to delete entire row of empty cells in columns across multiple sheets.

Hello, I have a large matrix that I need to break down. I take a mastersheet and copy it multiple times. The name of the sheet is determined by the value of cell in Range A3:AG3. So I copy, create, name and then hide all the columns except for the column that matched the name of the sheet. I also delete all the rows that have empty cells in the column displayed. It all works except for ActiveSheet.Columns(firstCol).SpecialCells(xlCellTypeBlanks).EntireRow.Delete. It copy, creates, names, hides for all the sheets but it only deletes the rows with the empty cells for the first copy created. How do I make it delete across all the worksheets it creates?

Please Login or Register  to view this content.