Listing Named Ranges

[Arturo]

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

 

[George Nicholson]

On a new worksheet: Insert>Name>Paste, 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.

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.

 

[Arturo]

D'oh.
Thank you George.

On a new worksheet: Insert>Name>Paste, 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.



named ranges, if any, to a sheet. Cannot seem to find that article.