M
Miguel
Hi,
I'm using a macro that delete rows that are blank. However, I want the macro
to delete rows that are equal to zero. This is my program:
Sheets("Group-rep").Select
Range("B11:B142").Select
Selection.SpecialCells(xlCellTypeBlanks).Select
Selection.EntireRow.Delete
Range("A1").Select
what should I put on the SpecialCells?
Is there a way in the help option to find out what I should use?
Thanks
Miguel
I'm using a macro that delete rows that are blank. However, I want the macro
to delete rows that are equal to zero. This is my program:
Sheets("Group-rep").Select
Range("B11:B142").Select
Selection.SpecialCells(xlCellTypeBlanks).Select
Selection.EntireRow.Delete
Range("A1").Select
what should I put on the SpecialCells?
Is there a way in the help option to find out what I should use?
Thanks
Miguel