Union Method with multiple worksheets

[Jeff B]

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)

 

[Norman Jones]

Hi Jeff,

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

 

[Tom Ogilvy]

Just to add a thought.
The parent of a range is a worksheet. Since the union returns a range, it
would not be able to have a parent if the union were composed of multiple
sheets.

 

[Norman Jones]

Hi Tom,

I prefer your explanation.