Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old September 13th 04, 04:12 PM posted to microsoft.public.excel.programming
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:

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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
return empty string value if cell is blank Nat Excel Discussion (Misc queries) 2 April 1st 08 08:55 PM
Leaving an empty cell empty GRL Excel Discussion (Misc queries) 4 April 22nd 06 05:47 PM
why a reference to an empty cell is not considered empty Nicoscot Excel Discussion (Misc queries) 10 March 10th 06 05:36 AM
Copy a string text to cell if another cell not empty Pasmatos Excel Discussion (Misc queries) 0 November 25th 05 03:54 PM
Can blank cells created using empty Double-Quotes not be empty?? JohnI in Brisbane Excel Programming 6 September 7th 03 11:22 PM


All times are GMT +1. The time now is 12:25 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017