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.

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

--

HTH

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


"bryantebbe" wrote in message
...
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.

Thanks Bob,

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

Bryan

"Bob Phillips" wrote:

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

--

HTH

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


"bryantebbe" wrote in message
...
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.

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.