Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Given Address, find named ranges that contain it
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Replace a spreadsheets named cells/ranges with exact cell address. | Excel Discussion (Misc queries) | |||
Replace a spreadsheets named cells/ranges with exact cell address. | Excel Programming | |||
Replace a spreadsheets named cells/ranges with exact cell address! | Excel Programming | |||
How do I find all named ranges in VB.NET? | Excel Discussion (Misc queries) | |||
How do I find all named ranges in VB.NET? | Excel Programming |