View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
sloth sloth is offline
external usenet poster
 
Posts: 26
Default 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?