| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Method 'Intersect' of object '_Global' failed
I have an Excel 97 - 2003 add-in that is getting a failure on the following
statement: Intersect(myArea, Selection) The error message is: Method 'Intersect' of object '_Global' failed myArea is defined to be a Range and is set to $A$31:$E$35. Selection is $A$17. I tried qualifying Intersect with Application. but that didn't help. Any ideas? TIA Josh |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Method 'Intersect' of object '_Global' failed
Never mind I figured it out.
|
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Method 'Intersect' of object '_Global' failed
Sounds like the ranges refer to different sheets (whether intentional or
not). This would cause that error I believe. -- Regards, Tom Ogilvy "Josh Sale" <jsale@tril dot cod wrote in message ... I have an Excel 97 - 2003 add-in that is getting a failure on the following statement: Intersect(myArea, Selection) The error message is: Method 'Intersect' of object '_Global' failed myArea is defined to be a Range and is set to $A$31:$E$35. Selection is $A$17. I tried qualifying Intersect with Application. but that didn't help. Any ideas? TIA Josh |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Method 'Intersect' of object '_Global' failed
Just so.
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Method 'Range' of object '_global' failed | Excel Discussion (Misc queries) | |||
| Method 'Range' of object '_Global' failed | Excel Programming | |||
| Method 'Range' of object '_Global' failed | Excel Programming | |||
Linear Mode
