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.
|