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