View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
DanPtWash DanPtWash is offline
external usenet poster
 
Posts: 2
Default Macro to delete row if

Ben,

I don't know if this is the best way, but this is what I use to delete rows
which contain blank cells.
Note: where column "H" contains the blank cells I am looking for.

Columns("H:H").Select
Selection.SpecialCells(xlCellTypeBlanks).Select
Selection.EntireRow.Delete

"Benjamin" wrote:

I am looking for a macro to delete an entire row if a cell contains certain
words or is blank.

Thanks.