Excel Tabs

  • Thread starter Thread starter ckane
  • Start date Start date
C

ckane

I have a worksheet with several tabs. Each tab is a different persons name.
Is there a way to have the name on the tab automatically show up in a
specific cell on the worksheet. Thank you!
 
it's the last thing in =cell("filename") maybe you could use MID and RIGHT or
something to pick it out?
 
Hi,

As has been suggested the CELL function will give you the information.

But if you want the sheet name of each individual sheet remember to
include a cell reference in the CELL function otherwise all sheets will
display the same information, which will at least be correct for 1 of
the sheets :)

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

Cheers
Andy
 
Back
Top