display defined names in excel

[Guest]

I would like a way to print out the list of defined names in a workbook.


thanks,

Mike

 

[RichardSchollar]

Mike

Go Insert>Name>Paste and hit the Paste List button in the dialog that
opens.

Hope this helps!

Richard

 

[Don Guillett]

Sub listnames()
For i = 1 To ThisWorkbook.Names.Count
Cells(i, 1) = Names(i).Name
Cells(i, 2) = Names(i)
Next i
End Sub

 

[Guest]

Thanks for the help, the solution Richard offered worked perfectly.