Given Address, find named ranges that contain it

  • Thread starter Thread starter INTP56
  • Start date Start date
I

INTP56

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
 
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.
 
Back
Top