worksheet name in a cell

[calin]

how can I display the tab name of a woork sheet in a cell of the same workshet?

[Dave Peterson]

The workbook has to be saved for this to work:

=MID(CELL("filename",a1),FIND("]",CELL("filename",a1))+1,255)

calin wrote:
>
> how can I display the tab name of a woork sheet in a cell of the same
> workshet?
>
> --
> calin
> ------------------------------------------------------------------------
> calin's Profile: http://www.excelforum.com/member.php...o&userid=29265
> View this thread: http://www.excelforum.com/showthread...hreadid=489826

--

Dave Peterson

[calin]

Thanks a lot!