Code to List Named Ranges for each Sheet not working

[leaning]

Hello!

I have a Tester Workbook from which I run code on other workbooks.

What I wanted is to go through each sheet in the examined workbook and then make a list of the named ranges from each sheet to a new sheet.

I found RoyUk's code on this forum and tried to modify it. but I messed something up.

It makes a new sheet, but it is not going through each sheet and the names on those sheets properly.

Here's the code:

Please Login or Register  to view this content.

I appreciate the help!

Lost

[AlvaroSiza]

If you have not already, I would strongly suggest the Name Manager add-in. It's a must for heavy workbooks and should do what you are after with ease.

http://www.jkp-ads.com/officemarketplacenm-en.asp

[MaczaQ]

Hello,

I wrote for you following code - it should cover your needs

Please Login or Register  to view this content.

[leaning]

Maczaq,

I appreciate your help!

If the workbook to be examined has 10 sheets, there should be either 10 ReportSheets (one for each sheet), or preferably, all the names from each of the sheets all on one ReportSheet (names for sheet1 in rows 1-15, names for sheet2 in rows 16-18, etc.)

Your code just looks at the activesheet, not all the sheets.

Any ideas?

AlvaroSiza: Users here prefer macros over add-ins. Thanks for the feedback!

Respectfully,

Lost

[MaczaQ]

hi again

I think my code works for all names defined in activeworkbook
here is a little update

Please Login or Register  to view this content.

[leaning]

MaczaQ,

Almost there.

Where do I put it in your code so that it also displays the sheet name that named range is on? I don't care if the report repeats data. I just want it to positively identify that a certain range is workbook level or sheet-level, and if sheet-level, what sheet it is on.

SheetName NamedRange Refers to Sheet or Workbook Level
Sheet1 Dog Sheet1!A1 Sheet
Sheet1 Cat .....etc.

Thanks!

Lost

[leaning]

MaczaQ/All,

This code never worked exactly like I wanted it to, but I found a better one (and it's free):
Jan Karel Pieterse's Name Manager: http://www.jkp-ads.com/OfficeMarketPlaceNM-EN.asp

The undoubted shiznit when it comes to showing everything there is about your Named Ranges (both workbook/global- and sheet-level).

Thanks!

Lost

[AlvaroSiza]

If you have not already, I would strongly suggest the Name Manager add-in. It's a must for heavy workbooks and should do what you are after with ease.

http://www.jkp-ads.com/officemarketplacenm-en.asp

AlvaroSiza: Users here prefer macros over add-ins.

You landed where I originally suggested. Perhaps a bit more patience next time. We are here to help. Glad you are happy with the add-in.