Method 'Union' of object '_Global' failed error
 

I keep getting this message when I try to use the union method on a
bunch of defined names. Here's my code:

Set rng1 = Union(Range(Application.Names!Revenue),
Range(Application.Names!Opex),etc....)

Anyone know what this error means and how to prevent/troubleshoot it?

Method 'Union' of object '_Global' failed error
 

You want something more like...

Set rng1 = Union(Sheets("Sheet1").Range("Revenue"),
Sheets("Sheet1").Range("Opex"),etc....)


--
HTH...

Jim Thomlinson


"sloth" wrote:

I keep getting this message when I try to use the union method on a
bunch of defined names. Here's my code:

Set rng1 = Union(Range(Application.Names!Revenue),
Range(Application.Names!Opex),etc....)

Anyone know what this error means and how to prevent/troubleshoot it?