Cell in named range

Is there a way to determine if a cell is part of one or more named ranges?
Thanks

One possible way would be to use VBA. The example code below will loop through the named ranges and see if the selected cell appears anywhere within a named range and will throw up a message box with the name of the range if it does.
You could change Selection to a specific range if that would work better. Not much info to go on...

Please Login or Register  to view this content.

BSB

Hi there,

Take a look at the attached workbook and see if it does what you need. It uses the following code:

Please Login or Register  to view this content.

The highlighted values may be altered to suit your requirements.


Hope this helps - please let me know how you get on.

Regards,

Greg M

Hi again,

Following on from BSB's approach, the attached workbook will check for intersections with ALL of the named ranges contained in a workbook. It uses the following code:

Please Login or Register  to view this content.

Hope this helps,

Regards,

Greg M

Thank you all, I appreciate it.

Hi again,

Many thanks for your feedback and also for the Reputation increase - much appreciated!

You're welcome - glad I was able to help.

Best regards,

Greg M