EntireRow.Delete
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!
|