If the zero length strings are values--not formulas, then you could select your
range
edit|replace
what: (leave blank)
with: $$$$$ (some unique string)
replace all

then reverse it
edit|replace
what: $$$$$
with: (leave blank)
replace all

(This cleans up those formulas that evaluated to "" that were converted to
values.)

Alternatively, you could modify Chip's routine.

Depending on what Chip's code was, though.

if isempty(.cells(irow,icol)) then
.rows(irow).delete
end if

could become

if .cells(irow,icol).value = "" then
.rows(irow).delete
end if

You may want to post your code to get a better answer.

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.

--

Dave Peterson