Method 'Intersect' of object '_Global' failed

  • Thread starter Thread starter Josh Sale
  • Start date Start date
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
 
Sounds like the ranges refer to different sheets (whether intentional or
not).

This would cause that error I believe.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Intersect & Hyperlink 2
intersect method error 5
"Method 'Worksheets' of object '_Global' failed " 1
Error 1004 Method 'Range' of object '_Global' failed 4
Method 'Columns' of object '_Global' failed 2
method 'range' of object'_global' failed 2
method Cells of object _global failed 2
Receiving error 1004 - Method 'Rang' of object '_Global' failed 2

Back
Top