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