Logit,
It sounds like we're in very similar circumstances, but you're well up the learning curve from me.
I'd not thought of the cells' contents, and your logic would need to be considered for a test on the contents. But my understanding of the Intersect function is that it's only testing to see if the ranges have any cells in common and that it does not look at their contents. If that's correct, then the advantage doesn't seem to apply.
Very respectfully,
Larry
|