Given Address, find named ranges that contain it
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.
--
Tim Zych
SF, CA
"INTP56" wrote in message
...
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
|