List of worksheet names for a workbook

[KinhinXiu]

I have Excel 2000. As you know, each Excel workbook can have many worksheets. Is there a way for me to ask Excel to print a list of worksheet names of a particular workbook without typing or handwriting each worksheet name down?

 

[Aladin Akyurek]

Yes. A perfect job for free ASAP Utilities, which you can download from:

http://asap-utilities.com

 

[Dave Patton]

There are quite a variety of ways to do this but I do not have my information at hand.


1. search for a VBA solution

2. Use Sheetname from Morefunc add-in. It includes some very valuable functions.

Download the morefunc add-in from

http://longre.free.fr/english/index.html

and install/activate the add-in via Tools|Add-Ins.

Example

I put the formula =SHEETNAME(ROW(),0) in A1 and copied it down. I used row() to specify 1; if the put the formula in a different cell, adjust this part as necessary.

=SHEETNAME(ROW(),0)


3. J Walkenbach utilities

see information on his site http://j-walk.com/ss/
This message was edited by Dave Patton on 2002-08-25 21:15

 

[Aladin Akyurek]

On 2002-08-24 15:39, Dave Patton wrote:

There are quite a variety of ways to do this but I do not have my information at hand.


1. search for a VBA solution

2. Use Sheetname from Morefunc add-in. It includes some very valuable functions.

Download the morefunc add-in from

http://longre.free.fr/english/index.html

and install/activate the add-in via Tools|Add-Ins.

Example

I put the formula =SHEETNAME(ROW(),0) in A1 and copied it down. I used row() to specify 1; if the put the formula in a different cell, adjust this part as necessary.

=SHEETNAME(ROW(),0)


3. J Walkenbach utilities

see information on his site http://j-walk.com/ss/

Make ROW() --> ROW(1:1)