This excellent utility has a way to list all range names in a worksheet.

http://www.asap-utilities.com


"tthe" wrote in message
...
how can i list all the worksheet names in a master sheet?
is there a formula? an easy way??