Given Address, find named ranges that contain it

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

INTP56 - 23 Jan 2008 00:06 GMT

Excel 2003

By whatever method, I get to a cell on a worksheet.

Now I want to find out if this cell has a name, or is contained in other
named ranges on the worksheet.

Is there a direct way to get this information? Or do I have to iterate
through all the names myself and determine (Union?) if my cell is in the
named range?

Thanks,

Bob

Reply to this Message

Tim Zych - 23 Jan 2008 00:42 GMT

As far as whether an exact range has been named, <range>.Name.Name will
return the range name (first found by alphabetical order for
multiple-names), if there is one. Otherwise it will return an error.

As far as whether a range intersects a named range (but not is the range
exactly), and/or to find all of the names for a range with multiple names, I
do believe you would need to loop.

Signature

Tim Zych
SF, CA

> Excel 2003
>
[quoted text clipped - 10 lines]
>
> Bob

Reply to this Message