Invisible Contents

[Jeff]

I have a macro that is trying to delete a row if the cell
in Col A is empty.

However, it is not deleting the rows like it should. The
appropriate cells appear empty and when I hold the cursor
over the "activecell" in VB it shows """".

Even though I can't see it, there must be something there
because when I manually "clear contents" for a specific
cell, the macro works like it is supposed to.

The file I'm using was originaly saved as an Excel 2.1
worksheet. I have tried saving it as 5.0 and 97 and as an
Excel workbook but I get the same results unless I
manually clear contents on each blank cell.

Is there a way to clear the contents only on those cells
without data?

Thanks for the help......

 

[Bob Flanagan]

Jeff, try a test like the following:

If Range("A12") ="" then
'delete row
end if

Bob Flanagan
Macro Systems
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel