try

=MID(CELL("filename",Sheet2!A1),FIND("]",CELL("filename",Sheet2!A1))+1,255)

which returns "Sheet2"

"Simon P California" wrote:

How can I refer to the 'name' of a worksheet in a cell.
So that if I change the name of the worksheet, the new name will be
reflected in that cell.

(like worksheet1.name, reference the 'name attribute' of a worksheet).

Thanks in advance,
Simon