Names

  • Thread starter Thread starter Emilio Pena
  • Start date Start date
E

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.
 
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
 
Emilio Pena said:
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.
Click to expand...

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
 
Back
Top