Thread: Method 'Union' of object '_Global' failed error
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Thomlinson Jim Thomlinson is offline
external usenet poster
  
Posts: 5,939
Default 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?


Reply With QuoteReply With Quote