buggy macro 'intersect' of object of object'_global failed" when deleting rows

**Kezwick** · 10-18-2011, 03:32 AM

hey all sorry to keep bothering you all have used my limited knolage to try and de bug this but no avail.
it says "method 'intersect' of object of object'_global failed"

Please Login or Register  to view this content.

many thanks for this you are all gods!!!!

**romperstomper** · 10-18-2011, 06:02 AM

You need to specify the sheet for both ranges:

Please Login or Register  to view this content.

**Kezwick** · 10-18-2011, 06:58 AM

chears buddy didnt know that (now i do :D)
thanks again

**romperstomper** · 10-18-2011, 07:11 AM

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save