Then you have something amiss. Empty is only valid for Variants. If rng
is a Range object, you should use

If Not rng Is Nothing Then...

Note the use of Is rather than =.

By using

If not rng = Empty

you're comparing rng's default .Value property (i.e., the value stored
in rng) to Empty. If the cell is blank, True will be returned. If not,
you'll get False. In either case, it has nothing to do with whether rng
was set correctly.



In article ,
"Steph" wrote:

But that's the strange thing....I do have rng Dim'd as Range!