There is an ADD-IN called ASAP Utilities that will put all named ranges in a
new workbook, along with many, many other useful tools.

http://www.asap-utilities.com/

Mike F
"ranswert" wrote in message
...
Is there a way to write a procedure that will pull all the cell names off
a
range of cells and put it into a list?
Thanks