Define worksheet name in cell reference 1

[dolodolo]

I'd like to define the worksheet name as the cell reference so that it appears in the title of the worksheet - not using the header or footer.

Any help would be appreciated.

 

[sxschech]

=CELL("filename")

Found at:

http://office.microsoft.com/en-us/excel/HA010346271033.aspx

 

[SkipVought]

actually it would be...
[tt]
=RIGHT(CELL("filename"),LEN(CELL("filename"))-FIND("]",CELL("filename")))[/tt]

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}