formula to capture tab name?

  • Thread starter Thread starter jenns
  • Start date Start date
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!
 
Try the following:

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


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com (e-mail address removed)
 
Jenns,

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

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