Excellent point -- I sometimes use formulas that evaluate to "", and I
hadn't considered this (although so far I haven't checked for empty
cells in these cases).

I shall be switching approach then. Thanks.

--
Dianne

In ,
Dave Peterson typed:
Depends on what you're looking for.

if you check
range("a1").value = ""

Then A1 could have a formula that evaluates to "" and this check
would return true.
=if(b132,b1,"")

If you really mean you want the cell to be empty--no value, no
formula, then isempty() is the way to go.


Dianne wrote:

Ron,

PMFJI, but this seems a good place to ask about empty cells.

VBA Help for IsEmpty says that it checks for uninitialised
variables, so I've been using Range("A1").value = "" to check for an
empty cell. Am I likely to run into trouble doing it this way? Is
IsEmpty preferable?

Thanks for any insight.