Hi

I have done some searching of the archive but not successfully for the
following problem.

I have datafiles produced from an accounting ledger system and <null cells
are produced for columns that have no data. The null cells are zero length
strings that show up as text items i.e. ISTEXT(A1) is TRUE, but equally
LEN(A1) is 0 and ISBLANK(A1) is FALSE. When in Excel itself, simply editing
the cell makes it revert to a true empty (blank) cell.

What is the most efficient way of identifying the cells in VBA and then
removing them, please? (Ideally, I don't want to test each cell). The cells
can be anywhere in the sheet data but are often in whole columns.

Thanks

Tim