Spreadsheet; Determining if a cell is EMPTY

28102016, 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.


31102016, 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 

31102016, 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 

« Next Oldest  Next Newest »

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