It's easier to understand if you extract the cell part
=CELL("filename",A1)
will return path filename and sheet name
then mid "extracts" the sheet name which is at the end and the last
character before the sheet name is "]"
--
Regards,
Peo Sjoblom
"Jeff B" wrote in message
...
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?
|