formula to capture tab name?

J

jenns

Does anyone know of a formula that can be written to populate a cell
with the name of a worksheet tab?

Specifically, if I have "Sheet3" as my tab name, I'd like to write a
formula in a cell (say A2) so that if "Sheet3" is changed to "Name"
cell A2 will update with the value "Name".

Thanks!
 
B

Bob Phillips

Jenns,

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

It only works for workbooks that have been saved at least once.
 
Top