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