As a possibly simpler and more efficient alternative to the macro, have you
tried using Excel's Autofiltering option to select rows? In the Standard
Toolbar, go to Data - Filter - Auto Filter or Advanced Filter. For more
information, look up Autofilter in Excel's online help.

----
Regards,
John Mansfield
http://www.pdbook.com

" wrote:

I am trying to delete blank rows using Chip Pearson's macro; also
tried acouple of addins that delete blank rows.
My problem that the cells are not really blank, apparently they have
zero length strings.
Is there a way to delete zero length string rows, or to convert zero
length string cells to blank cells, and then run the delete blank rows
macro?
The cells' data was achieved via copy/paste from another sheet, which
was achieved from formulas such as =IF(D29="","",ha).
I tried such as =IF(D29="",G32,ha), where G32 is a really blank cell.
But some of the formulas involve time, and the latter formula caused
the time cells to be wrong.
Thanks for any suggestions.