Return Worksheet Name in Cell

[nofzinger]

Hello,

I would like a list of all of the worksheets in my workbook. Is there an easy way to say:

A1=worksheet name
A2=worksheet+1 name
A3=worksheet+2 name

So that I can easily get a list of all of the worksheets in my workbook? Or not?

thanks.

[contaminated]

Install this function

Please Login or Register  to view this content.

How to use:

1. Copy above code.
2. In Excel press Alt + F11 to enter the VBE.
3. Press Ctrl + R to show the Project Explorer.
4. Choose Insert -> Module.
5. Paste code into the right pane.
6. Press Alt + Q to close the VBE.
7. Save workbook before any other changes.

Then in A1
=WorksheetNames(B1)
Copy Down

[JBeaucaire]

I like the function idea, but I would use this approach:

Please Login or Register  to view this content.

Used as:

=WSNAME(1)
=WSNAME(2)
...etc

[nofzinger]

Great! Thank you!