ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   List of all names in EXCEL workbook (https://www.excelbanter.com/excel-programming/324761-re-list-all-names-excel-workbook.html)

Dave Peterson[_5_]

List of all names in EXCEL workbook
 
And if you're working with names, do yourself a giant favor and get Jan Karel
Pieterse's (with Charles Williams and Matthew Henson) Name Manager

You can find it at:
NameManager.Zip from http://www.oaltd.co.uk/mvp

NameSearcher wrote:

How do I get a list of all the names being used in an EXCEL workbook? The
"Insert\Names... " sequence of commands gets a list you can view on the
screen, about 10 at a time. I would like to copy/paste the whole list. I
would also like the list to include (as a separate column) associated text
showing the references for each name.


--

Dave Peterson


All times are GMT +1. The time now is 04:53 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com