Thread
:
IsEmpty() Returns False in empty cells
View Single Post
#
2
Posted to microsoft.public.excel.programming
Tom Ogilvy
external usenet poster
Posts: 27,285
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
Reply With Quote
Tom Ogilvy
View Public Profile
Find all posts by Tom Ogilvy