Hi Jeff,

I do not believe that a range object can be 3D and, therefore, a union is
consrtained to a single sheet.

---
Regards,
Norman



"Jeff B" wrote in message
...
I can easily form a "union" of ranges on the same worksheet but bwtween
range
on two or more sheets. I get a 1004 error anyway I try it.

Any ideas on how to do this?

Set R2 = Worksheets(1).Range("a22:a200")
Set R1 = Worksheets(2).Range("B2:B22")
Set rngUnion = Union(R1, R2)

--
Jeff B