Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
IsEmpty() Returns False in empty cells
Occasionally when I use IsEmpty to see if a cell contains data like
"IsEmpty(Cells(x,y))" it returns "False" when there is nothing there. I've tested the cell with Len(Cells(x,y)) and it returns 0. Does anyone know why this happens or how to get around it? Thanks, John Hutchins |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
IsEmpty() Returns False in empty cells
It can contain a zero length string. This can be cause when you do a Paste
Special, Value when the cell contained a formula displaying "" =if(true,"",false) as an example. -- Regards, Tom Ogilvy "John Hutchins" <John wrote in message ... Occasionally when I use IsEmpty to see if a cell contains data like "IsEmpty(Cells(x,y))" it returns "False" when there is nothing there. I've tested the cell with Len(Cells(x,y)) and it returns 0. Does anyone know why this happens or how to get around it? Thanks, John Hutchins |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
IsEmpty() Returns False in empty cells
IsEmpty(), while it seems to work for really empty cells, is meant to
determine if a variable has been initialized. You may be better off testing as follows if you want cells with formulas that return null strings to be considered empty: ?Cells(1, 1) = "" False -- Vasant "John Hutchins" <John wrote in message ... Occasionally when I use IsEmpty to see if a cell contains data like "IsEmpty(Cells(x,y))" it returns "False" when there is nothing there. I've tested the cell with Len(Cells(x,y)) and it returns 0. Does anyone know why this happens or how to get around it? Thanks, John Hutchins |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLOOKUP worksheet function returns zero for empty cells | Excel Worksheet Functions | |||
IF formula returns FALSE | New Users to Excel | |||
Any number above 15 returns false when it should be true | Excel Worksheet Functions | |||
How to do nothing if @IF returns FALSE? | Excel Worksheet Functions | |||
IF Function returns False instead of 0 | Excel Worksheet Functions |