J
Jeff B
How do I link a cell to the name of the worksheet tab?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
P
Peo Sjoblom
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
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
P
Peo Sjoblom
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
=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 said:That works perfect. I don't understand the formula, but it gives the
result
I wanted.
Thank you.
Jeff
Peo Sjoblom said: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 said:How do I link a cell to the name of the worksheet tab?