Excel 2003 worksheet name function?
 

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.

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



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

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

--
Regards Ron de Bruin
http://www.rondebruin.nl


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

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


"eddie_zoom" wrote:

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.