Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,758
Default 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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Print list of names of all sheets in a workbook Jo Excel Discussion (Misc queries) 1 September 24th 09 05:00 PM
workbook names list Steve Excel Discussion (Misc queries) 0 March 18th 09 01:46 PM
create a random list of names from a list of names in EXCEL Givvie Excel Worksheet Functions 2 October 23rd 06 05:10 AM
How do I display list of tab names used in a workbook on a sheet tmottur Excel Worksheet Functions 2 December 1st 05 09:42 PM
List of all names in EXCEL workbook NameSearcher Excel Programming 4 March 7th 05 06:33 PM


All times are GMT +1. The time now is 09:30 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"