I need a list of my tabs!

[DocumentControlPrincess]

I have a project in Excel that has about 300 tabs. Is there a way that I can
get a list of the tabs only?

 

[Peo Sjoblom]

If you right click the on the arrows to the left of the tabs you will get a
list
If you need a list in your cells you need to run a macro


http://www.mvps.org/dmcritchie/excel/buildtoc.htm

there is a UDF that will list all sheets on that page

--


Regards,


Peo Sjoblom





"DocumentControlPrincess"

 

[DocumentControlPrincess]

Cool thanks!
--
~Christina

If you right click the on the arrows to the left of the tabs you will get a
list
If you need a list in your cells you need to run a macro


http://www.mvps.org/dmcritchie/excel/buildtoc.htm

there is a UDF that will list all sheets on that page

--


Regards,


Peo Sjoblom





"DocumentControlPrincess"