Get sheet name from a named range's Name object

excel named-ranges
Shark picture Shark · Nov 14, 2011 · Viewed 24.3k times · Source

I have:

Microsoft.Office.Interop.Excel.Workbook wb;
Microsoft.Office.Interop.Excel.Name name;

Is there any way to get the worksheet name that the named range is on in the given workbook, assuming I've gotten the named range's Name object and wb already?

Answer

Raymond Hettinger picture Raymond Hettinger · Nov 14, 2011

Yes, use the Parent property to work your way up the object hierarchy:

ws = name.RefersToRange.Parent.name;

Related questions

How do I reference a cell within excel named range?

For example, I have a named range A10—A20 as Age; how do I get Age[5] which is same as A14. I can write "=A14" but I did like to write "=Age$5" or something similar.

Read More
VBA- Find location of first cell in named range to reference heading row of spreadsheet

What I have is part descriptions that I have split into separate columns. All columns have headings, but not all columns contain information for every part, ex: some might have size, material, and temp while another may have just size …

Read More
Referencing Dynamic Named Range in Excel Formula

I have a table in Excel with column headings that correspond to part of a dynamic named range elsewhere in my workbook. For example, I have these column headings: "10", "20", etc., and these dynamic named ranges: "ExampleRange10", "ExampleRange2", etc. I'd like …

Read More