View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
MIguel MIguel is offline
external usenet poster
 
Posts: 33
Default Delete rows using VB

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