List of worksheet names for a workbook

KinhinXiu

New Member
Joined
Aug 23, 2002
Messages
5
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?
 

Excel Facts

Can you sort left to right?
To sort left-to-right, use the Sort dialog box. Click Options. Choose "Sort left to right"
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
 
Upvote 0
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) :)
 
Upvote 0

Forum statistics

Threads
1,213,546
Messages
6,114,256
Members
448,558
Latest member
aivin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top