That works perfect. I don't understand the formula, but it gives the result
I wanted.

Thank you.

Jeff


"Peo Sjoblom" wrote:

Do you mean that you want the sheet name in a cell?
Workbook has to be saved,

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

you can put that formula in any cell, the cell function needs a reference
and A1 can be replaced with any cell reference

If you mean that you want to change the sheet name depending on what's in a
cell,
then you would need VBA (macro), if so post back


Regards,

Peo Sjoblom

"Jeff B" wrote:

How do I link a cell to the name of the worksheet tab?