Excel 2003 worksheet name function?

E

eddie_zoom

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

N Harkawat

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