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?
|