View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default 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