Method 'Union' of object '_Global' failed error

  • Thread starter Thread starter sloth
  • Start date Start date
S

sloth

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?
 
You want something more like...

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