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


thanks,

Mike

Mike

Go InsertNamePaste and hit the Paste List button in the dialog that
opens.

Hope this helps!

Richard


On 14 Mar, 15:55, Mike C wrote:
I would like a way to print out the list of defined names in a workbook.

thanks,

Mike

Sub listnames()
For i = 1 To ThisWorkbook.Names.Count
Cells(i, 1) = Names(i).Name
Cells(i, 2) = Names(i)
Next i
End Sub
--
Don Guillett
SalesAid Software

"Mike C" wrote in message
...
I would like a way to print out the list of defined names in a workbook.


thanks,

Mike

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

"RichardSchollar" wrote:

Mike

Go InsertNamePaste and hit the Paste List button in the dialog that
opens.

Hope this helps!

Richard


On 14 Mar, 15:55, Mike C wrote:
I would like a way to print out the list of defined names in a workbook.

thanks,

Mike