Cell in named range

[Len Silva]

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

[BadlySpelledBuoy]

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

[Greg M]

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

[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

[Len Silva]

Thank you all, I appreciate it.

[Greg M]

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