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

Method 'Intersect' of object '_Global' failed
 

Never mind I figured it out.

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

Method 'Intersect' of object '_Global' failed
 

Just so.