Combine and search each cell in three variable ranges

[Ochimus]

"Static" code to combine three ranges would be

Please Login or Register  to view this content.

Can't fathom how to combine them as "variable" ranges?

Please Login or Register  to view this content.

All suggestions and pointers appreciated

Ochimus

[ptmuldoon]

You sort of lost me on what you trying to do. But what if you assigned each range a Name? Can you work with that? Each Range could then be called separately and or even joined with a UNION?

[millz]

Please Login or Register  to view this content.

Maybe you meant " : " for the red comma.

[Ochimus]

Apologies for short delay in getting back.

Many thanks for both responses, as a result of which I now have a working solution, and can mark this as "Closed"!

Ochimus