Linking to Tab Name
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?
|