display defined names in excel
I would like a way to print out the list of defined names in a workbook.
thanks, Mike |
display defined names in excel
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 |
display defined names in excel
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 |
display defined names in excel
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 |
All times are GMT +1. The time now is 04:16 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com