On a new worksheet: InsertNamePaste, then click "PasteList" in the dialog.

You'll get a list of the NamedRanges, and their addresses, in the workbook.

--
George Nicholson

Remove 'Junk' from return address.


"Arturo" wrote in message
...
I vaguely remember a Q article with example code that generates a list of
named ranges, if any, to a sheet. Cannot seem to find that article.
Appreciatively,
Arturo