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:
How to check this?For Each RangeName In wb.Names Debug.Print RangeName.Name Debug.Print Application.Range(RangeName.Name).RefersToRange.Parent.Name Next RangeName
Best,
Jacek
Bookmarks