Empty cell?
"GARYWC" wrote in message
=IsText(A1) returns "True" for the allegedly empty cell.
=Len(A1) returns '1' for the allegedly empty cell (even though nothing is
displayed in the cell) so I will delete the cell.
If Len(A1) = 1 the cell contains one character, check what =Code("A1")
returns.
Peter T
|