short version of Index/Table of Contents
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.
|