| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Error 1004 Method 'Range' of object '_Global' failed | Excel Programming | |||
| Run-time error '1004': Method 'Cells' of object _Global failed | Excel Programming | |||
| Run-time error '1004': Method 'Range' of object '_Global' failed | Excel Programming | |||
| <Method 'Range' of object '_Global' failed error | Excel Programming | |||
| Error 1004: Method 'Cells' of object '_Global' failed | Excel Programming | |||
Linear Mode
