Method 'Intersect' of object '_Global' failed

J

Josh Sale

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
 
T

Tom Ogilvy

Sounds like the ranges refer to different sheets (whether intentional or
not).

This would cause that error I believe.
 
Top