Do you know of any way to get it without VBA? I have a lot of users who will
get nervous about running a macro.

Thanks again,

Jon




"Roger Govier" wrote:

Hi Jon

If a VBA solution is acceptable to you then this short piece of code will
list all the sheet names for you, on whatever is the active sheet when you
run the macro.

Sub filltabNames()
Dim ws As Worksheet, i As Long
i = 1
For Each ws In ThisWorkbook.Worksheets
Cells(1, i) = ws.Name
i = i + 1
Next
End Sub

To Install
Copy code above
Alt+F11 to enter the VB Editor
Alt+I+M to insert a new module
Paste the code into the white pane that appears
Alt+F11 to return to Excel

To Use
Alt+F8
Select the macro nameRun
--
Regards
Roger Govier

"Jon Ratzel" wrote in message
...
Hi, right now I'm using the below formula to pull the tab name of the tab
I'm
working in. I need to also pull in the subsequent tab names into each
subsequent column. For instance cell A1 will have the current tab name but
B1
would be one tab to the right and C1 would be 2 tabs to the right, etc.
Can
anyone help me?


=RIGHT(CELL("filename",$A$1),LEN(CELL("filename",$ A$1))-FIND("]",CELL("filename",$A$1)))

As always, thanks! Jon

__________ Information from ESET Smart Security, version of virus
signature database 4825 (20100201) __________

The message was checked by ESET Smart Security.

http://www.eset.com




__________ Information from ESET Smart Security, version of virus signature database 4825 (20100201) __________

The message was checked by ESET Smart Security.

http://www.eset.com