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

http://www.asap-utilities.com


"tthe" <tthe@discussions.microsoft.com> wrote in message
news:001E6EA7-A9AD-44B4-A297-4D82B8B10F34@microsoft.com...
> how can i list all the worksheet names in a master sheet?
> is there a formula? an easy way??