Simple: list all named ranges

[Foeth]

As simple as that, what is the easiest way to construct a list with all named ranges in a sheet?

Of course I can use insert-->name..>define to see them all, but a nice automated list would be more useful (it's a few pages of names). Don't need the entire solution, a nudge in the right direction is sufficient.

 

[Aladin Akyurek]

On 2002-10-21 09:01, Foeth wrote:
As simple as that, what is the easiest way to construct a list with all named ranges in a sheet?

Of course I can use insert-->name..>define to see them all, but a nice automated list would be more useful (it's a few pages of names). Don't need the entire solution, a nudge in the right direction is sufficient.

Have a look at the Information option of the ASAP Utilities add-in, a free download from:

http://asap-utilities.com

 

[klb]

If you don't need everything that ASAP you:

From the Menu

Insert, Name, Paste, Paste List

Just make sure your cursor is in the cell where you want the list to start. You will get a list of all ranges and what they refer to.

 

[Andrew Poulsom]

Add a new worksheet and choose Insert, Name, Paste from the menu. Click the Paste List button.

 

[jcarlosd]

If you work with VBA, you can try this code:

Dim myObject
For Each myObject In Application.Names
i = i + 1
MsgBox Application.Names(i).Name
MsgBox Application.Names(i).RefersTo
Next

 

[Foeth]

Using Insert-->name-->paste-->paste list works and is quite simple (I might even say: Doh!.

The VBA code works as well, but as there are a few pages of names, rather click-intensive!

I'll try to download the ASAP tools as well, if I can talk our administator into allowing for downloads from FTP servers.

Thanks all. Now I can start the grateful task of documentation slightly faster.
This message was edited by Foeth on 2002-10-22 02:29

 

[klb]

Another good utility is the Excel Utilities addin at http://www.appspro.com.

I have had problems with ASAP and listing range names but Excel Utilities works wonders even giving the range names of the hidden ranges.

 

[Andrew Poulsom]

Here's another utility:

http://j-walk.com/ss/excel/files/namelist.htm