Listing Named Ranges

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.


Arturo said:
I vaguely remember a Q article with example code that generates a list of
Click to expand...
named ranges, if any, to a sheet. Cannot seem to find that article.
 
D'oh.
Thank you George.

George Nicholson said:
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.
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Globally Named Range Problem 4
Name the range AFTER copied to new sheet 6
Offset issue 3
Post my named ranges in column A 10
Add sheet and name it unless it already exists 12
Advanced Filter Error - I cannot spot my Error 3
InputBox to name a range 2
generating a whole random # from a list 2

Back
Top