Thanks Dave, Jim, and the Student. That clears it up for me. Otto
"Otto Moehrbach" wrote in message
...
Excel 2002, WinXP
I've been using
If Range(....)="" Then
to check if a cell is blank. I realize that this check is good only for a
blank cell, not for a cell that contains a formula that returns a blank
cell (True in both cases).
I've also used:
If IsEmpty(Range(....)) Then
and this has been working well including the formula case above (returns
False if it contains the formula). However, I've seen on this newsgroup
that "IsEmpty" should only be used to determine if a variable has been
initialized.
Can anyone clarify the use of IsEmpty to determine if a cell is truly
blank? Thanks for your help. Otto