View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
JE McGimpsey JE McGimpsey is offline
external usenet poster
 
Posts: 4,624
Default Empty cell and a the empty String

Yes. A null string is a value. So

Empty cell:

?IsEmpty(ActiveCell.Value)
True

Cell with null string (e.g., returned by a formula, eg. =IF(TRUE,"")):

?IsEmpty(ActiveCell.Value)
False

However, XL confuses the issue by clearing the cell if a null string is
assigned as a value:

ActiveCell.Value = ""
?IsEmpty(ActiveCell.Value)
True


In article ,
Niklas wrote:

Are their any differances between an empty cell and a cell containing the
empty String?