Names

[Emilio Pena]

I use a lot of names (I am talking about 400 names). Do
you know if there is a way you can see all the names so
you can erase them but not one by one, or at least print a
list of all the names in a file with the respective
references?
Any help will be appreciated.

 

[acw]

Emilio

The following code will allow you to print a list of the
names and their references on a sheet in the
activeworkbook.

Tony

Sub aaa()
For i = 1 To ActiveWorkbook.Names.Count
ActiveCell.Value = ActiveWorkbook.Names(i).Name
ActiveCell.Offset(0, 1).Value = Mid(ActiveWorkbook.Names
(i).RefersTo, 2)
ActiveCell.Offset(1, 0).Select
Next i
End Sub

 

[Dave Peterson]

I like the utility that Jan Karel Pieterse, Charles Williams and Matthew Henson
created.

You can find it at:
NameManager.Zip from http://www.bmsltd.co.uk/mvp

 

[Anon]

I use a lot of names (I am talking about 400 names). Do
you know if there is a way you can see all the names so
you can erase them but not one by one, or at least print a
list of all the names in a file with the respective
references?
Any help will be appreciated.

You can easily make a list with references.
Select a cell at the top left of a blank area (maybe A1 of a new sheet).
Insert > Name > Paste > Paste List