That would be (or like) if you can base the deletion on one column.
You certainly would not want to select all cells in a worksheet and
delete any row that has a empty cell within the used range.

If you want to delete all rows that are entirely empty based on
COUNTA use the macro at
http://www.mvps.org/dmcritchie/excel...emoveEmptyRows

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Niek Otten" wrote ...
EditGo to,Special, select Blanks
EditDeleteEntire row

"jayender.vs" ...
how to delete a row if the entire row is empty in Excel ?