How to get worksheetName from named range

**jaryszek** · 06-12-2019, 03:20 AM

hi,

i want to loop through whole workbook named ranges and get worksheet name from RefersTo column from Name Manager:

Screenshot_8.png

I tried with but i failed:

Please Login or Register  to view this content.

How to check this?

Best,
Jacek

**jindon** · 06-12-2019, 03:39 AM

You already have.

https://www.excelforum.com/excel-pro...ml#post5133161

**jaryszek** · 06-12-2019, 03:51 AM

o great sorry i forgot.

Jacek

How to get worksheetName from named range

LinkBack

Thread Tools

Rate This Thread

Display

How to get worksheetName from named range

Re: How to get worksheetName from named range

Re: How to get worksheetName from named range

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Change formula range according to Worksheetname

Listbox displaying named range B but Adding named range A to cell

[SOLVED] Compare cells to named range and create new sheets using related named range

Compare to workbooks, and copy certain values if they have the same worksheetname

[SOLVED] Copying worksheetname to powerpoint slide

[SOLVED] Determine what Named Range the Target Address is and return Named Range Name

Changing Worksheetname

Bookmarks

Bookmarks

Posting Permissions