Hi
why do you want to test this kind of ranges with
Intersect. They could never Intersect if they're on
different sheets?

-----Original Message-----
Hi

It seems that if the range 1 and range2 in Intersect
(Range range1, Range ranges2 , ...) are in different
worksheets this method throws HRESULT: 0x800A03EC
exception. I am using c#.

Looking for your advice.

Ai
.