Excel 2003 worksheet name function?

[Guest]

Is there an Excel 2003 function that refers to the worksheet name? I'd like
to enter a formula that refers to the name of the worksheet (also called
tab). Does anyone know if a function exists to do this, or of an easy way to
code this?

Thanks.

 

[N Harkawat]

=RIGHT(CELL("filename",$A$1),LEN(CELL("filename",$A$1))-FIND("]",CELL("filename",$A$1)))

 

[Ron de Bruin]

See Bob's site
http://www.xldynamic.com/source/xld.xlFAQ0002.html

 

[Guest]

=MID(CELL("filename",$A$1),FIND("]",CELL("filename",$A$1))+1,200)