Thanks. It makes sense. I really appreciate the help.


Norman Jones wrote:
Hi Peanburn,

I understand the "On Error" sequence, but am having trouble with

If Not rng1 Is Nothing Then

I would have liked to say

If rng1 Is Something Then (i.e. if there is something to copy)

but the keyword Something does not exist. Since, however, the keyword
Nothing does exist, I use this with a double negative to obtain a valid
equivalent expression.

---
Regards,
Norman


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...l-new/200602/1