How do I copy Tab into a single cell in Excel?

[Guest]

I want to name my Sheet Tab then have that name automatically put in a cell
in Excel. I am using 2003, but would need it to work in 2000 also.

 

[Bob Phillips]

Take a look at http://www.xldynamic.com/source/xld.xlFAQ0002.html

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Guest]

Thanks Bob,

I knew it could be done, You were very helpful.

Bryan

 

[Gord Dibben]

bryan

=MID(CELL("Filename",A1),FIND("]",CELL("Filename",A1))+1,255)

Enter in any cell.

Note: Workbook must have been saved at least once.

For more on this formula and others similar......path and name etc. see Bob
Phillips site.

http://www.xldynamic.com/source/xld.xlFAQ0002.html


Gord Dibben Excel MVP