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

On Wed, 19 Jan 2005 16:09:01 -0800, "bryantebbe"
wrote:

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.