VBA: check if cell is empty or has null string?

[OldManExcellor]

I know how to check if a cell is empty.

IsEmpty()

But how do I check if a cell has a null string?

And even more preferably, can I check both with one function?

 

[Sandeep Warrier]

How about

LEN(cell)=0

 

[Richard Schollar]

You may be able to use SpecialCells to distinguish between them (but SpecialCells is a pain if you are only looking at one cell at a time).