View Single Post
  #1   Report Post  
Old September 13th 04, 04:12 PM posted to microsoft.public.excel.programming
JE McGimpsey JE McGimpsey is offline
external usenet poster
First recorded activity by ExcelBanter: Jul 2006
Posts: 4,624
Default Empty cell and a the empty String

Yes. A null string is a value. So

Empty cell:


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


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

ActiveCell.Value = ""

In article ,
Niklas wrote:

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