Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
display defined names in excel
I would like a way to print out the list of defined names in a workbook.
thanks, Mike |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to keep names defined after a copy? | Excel Discussion (Misc queries) | |||
NAMES DEFINED | Excel Discussion (Misc queries) | |||
Tranferring names defined in one excel workbook to another workboo | Excel Discussion (Misc queries) | |||
Defined names | Excel Discussion (Misc queries) | |||
Using non defined names from another sheet | Excel Worksheet Functions |