Post Reply 
 
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Spreadsheet; Determining if a cell is EMPTY
28-10-2016, 12:38 AM
Post: #1
Spreadsheet; Determining if a cell is EMPTY
There appears to be no way to determine programmatically whether or not a spreadsheet cell is EMPTY (blank). Cells by default behave as if they store a ZERO even though they show BLANK on the screen. Have tried TYPE, STRING, DIM and various other functions in an effort to distinguish an EMPTY cell from a cell containing a user input ZERO value.
Find all posts by this user
Quote this message in a reply
31-10-2016, 07:35 AM
Post: #2
RE: Spreadsheet; Determining if a cell is EMPTY
Hello

try using A1(1) which will return the formula associated with the cell. If the cell is empty, it will return -1. else it will return the formula.

Of course, this is problematic if the cell formula is -1...

Cyrille
Find all posts by this user
Quote this message in a reply
31-10-2016, 09:00 AM
Post: #3
RE: Spreadsheet; Determining if a cell is EMPTY
Thanks Cyrille,
That works and is probably the closest I will get. It does provide a solution for the particular application I have in mind.
There has been quite a bit of discussion on this issue in the forums and as far as I can see no one else is aware of your workaround.
Regards
Chris Bragg
Find all posts by this user
Quote this message in a reply
Post Reply 


Forum Jump:


User(s) browsing this thread: 1 Guest(s)