I would suggest that you sort your list

Simple macro to populate with Sheetnames with a Sort (#SheetNamesSortedDownRows)
://www.mvps.org/dmcritchie/excel/buildtoc2.htm#SheetNamesSortedDownRows

HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"amyc" wrote in message ...
Yesterday I saw a short formula that made a simple TOC of worksheet (tab)
names. By entering a new sheet and using code, I was able to return in that
new sheet the list of all worksheet names for the user to see quickly. The
code did not save and I cannot find it.

It was not the long version posted in most responses via the hyperlink to
mvps.org.

If anyone gave that other short answer, please respond. thanks.