The workbook has to be saved for this to work.

=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,256)

HTH,
Paul

--

"OCA" wrote in message
...
Is it possible to make a cell entry automatically equate to the name of a
worksheet (as displayed in the tab at the bottom of the screen)?