Oops. I did misunderstand.

But glad you have a solution that works.

Jerry W. Lewis wrote:

Sorry if I was not clear; I agreed that IsEmpty() did not do what I wanted
while "Is Nothing" did; therefore "Is Nothing" is the approach I will be
using. Thank you for pointing me in the right direction.

Jerry

"Dave Peterson" wrote:

I don't think you missed any easy way of doing this, but I don't think you
should be using isempty() to check what may be a multi-cell range.

Checking isempty() with a single cell is ok. But that actually tells you if the
cell is empty--not a problem when you're looking at constants or formulas, but
could be a problem with cells with comments.



Jerry W. Lewis wrote:

The "Is Nothing" test for ranges (also suggested by Barb) nicely avoids the
difficulty of distinguishing no cells from empty cells. Thanks.
...

--

Dave Peterson