Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Test for empty cell
Hi!
I have a sheet, where I have a list of integers - if present - the field might be empty. How do I detect whether it is empty? Using r = MyFile.Sheets(1).Cells(i, 4) and later using r cuases problems, I'd like to set it to -1 in cases where it is empty. I get the file from elswhere, the contest of it is unknown BR Sonnich |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF function to test whether the cell value is equal to empty nest | Excel Worksheet Functions | |||
How can I test if a cell is empty? | Excel Discussion (Misc queries) | |||
test expression for empty cell in =SUMIF() | Excel Worksheet Functions | |||
Test for empty row | Excel Programming | |||
Test if Cell is Empty or Doesn't Exist | Excel Programming |