Sheet Names
This worked Barb,
Thank you.
"Barb Reinhardt" wrote:
Try this:
=RIGHT(CELL("filename",A2),LEN(CELL("filename",A2) )-SEARCH("]",CELL("filename",A2)))
Just don't put it in A2 or you'll get a circular reference.
"Marcus" wrote in message
...
Hello,
Is there a way yo can put a formula in a cell to have it equal what
the
sheet name is? Example( I have a spreadsheet with about 30 sheets in it.
Each
sheet has a different name. Instead of haveing to name every sheet, and
tab
twice is there a way I can rename the tab and have a formula i the sheet
that
will name the sheet the same as the tab name?)
|