Well, it is real dependency. But without you posting what you actually have
it will be a little difficult to see if it's not efficient enough (as it
could be) or not. I think it really depends on what you are doing. And yes,
you could be incurring quite a lot of overhead; depends on it's uses, again.

Please post.

--
Regards,
Zack Barresse, aka firefytr

"Adam" wrote:

Yeah, I think I perhaps have gotten you confused. This is the operator
intersect and not the VBA function.

Cells that use the intersect operator are able to figure out the row that
they reside in, with respect to a range that it lies in, to retrieve a
specific value in a target column.

Now I need to find out if this triangulation type of operator is causing me
undue performance issues.

Regards,
Adam