View Single Post
 
Old 12-28-2017, 02:38 AM
Larry_1 Larry_1 is offline Windows 10 Office 2010 64bit
Novice
 
Join Date: Dec 2017
Posts: 9
Larry_1 is on a distinguished road
Default

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
Reply With Quote