Thread: Empty cell?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
GARYWC GARYWC is offline
external usenet poster
  
Posts: 80
Default Empty cell?
=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.
Reply With QuoteReply With Quote