Thread: Empty cell?
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Peter T[_7_] Peter T[_7_] is offline
external usenet poster
 
Posts: 162
Default 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