Hi Jon

As you are wanting to copy across Row 1 and not down column A, I think Biff
meant his formula to say

=INDEX(MID(sheetnames,FIND("]",sheetnames)+1,255),COLUMNS($A$1:A1))

--
Regards
Roger Govier

"T. Valko" wrote in message
...
If you want a formula solution...

Create this defined formula
Goto InsertNameDefine
Name: SheetNames
Refers to:

=GET.WORKBOOK(1)&T(NOW())

OK

Then, enter this formula in cell A1:

=INDEX(MID(SheetNames,FIND("]",SheetNames)+1,255),ROWS(A$1:A1))

Copy across as needed.

--
Biff
Microsoft Excel MVP


"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 4826 (20100202) __________

The message was checked by ESET Smart Security.

http://www.eset.com




__________ Information from ESET Smart Security, version of virus signature database 4826 (20100202) __________

The message was checked by ESET Smart Security.

http://www.eset.com