InsertNamePaste and select Paste List. in the menubar

Or
http://www.j-walk.com/ss/excel/files/namelist.htm

Or use John's PUP 5 that have a option also
http://www.j-walk.com/ss/pup/pup5/index.htm


--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl



"David" wrote in message ...
I've seen reference to a freely available macro/function
for producing a list of Workbook names and addresses. It
could even be within the excel application. Can somebody
please point me at it before I go completely mad?
Thanks in anticipation
David