"GARYWC" wrote in message
Peter: I wish I had known about =Code("A1") before I deleted the allegedly
empty/blank cells.

But Len(A1) = 1 established the cell was not empty!

Maybe the cell was formatted with white text on white, or contained a space
or similar, or maybe all those cells contained the code to a secret fortune,
we'll never know:)

Peter T

Peter,
It's been my finding that many users hit the Spacebar key to clear a cell. I
don't get this; -perhaps just laziness so as not to have to reach for the
Backspace key?<g

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion