The workbook has to be saved

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

you need to use a cell reference in it, any cell refernece is OK


Regards,

Peo Sjoblom

"Bene" wrote:

I'd like to use the worksheet name to automatically adjust calculations in
the worksheet.

I know that it's possible to return the full file name using
CELL("filename") and feel sure that there must be a similar option for just
the worksheet name.

Can anyone help?

Many thanks.