Range Names - creating a list of

Krista327 · #1 (**permalink**) 10-26-05, 12:55

Is there any way to create a list of Range names? I created a bunch of names, and now I really need to view all of the names and the referenced cells so that I can use them in code.

shades · #2 (**permalink**) 10-26-05, 13:10

Howdy. The best thing to do is download the FREE add-in NameManager. It allows you to do that (and much, much more). I use it everyday (as part of the paid version of FastExcel add-in).

savbill · #3 (**permalink**) 10-27-05, 07:58

Quote:

Originally Posted by Krista327

Is there any way to create a list of Range names?

Use the Insert Name Menu: 'Insert->Name->Paste...'

This opens a dialog to paste a single name or list of all names. 'Insert->Names->Define...' allows you to view the list in a dialog window and change, delete, or redifine them.

mas_detokyo · #4 (**permalink**) 10-27-05, 08:19

An alternative with VBA code. This lists up all ranges.

Code:

Sub Temp()
Dim varName
For Each varName In ActiveWorkbook.Names
      Debug.Print varName.Name & varName.RefersTo
Next
End Sub

Cheers,

Krista327 · #5 (**permalink**) 10-27-05, 16:05

Great! Thanks for your help!

Internet Services

Web Development

Digital Marketing

Consumer Tech