Show the Worksheet Tab Name in a Cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a function that allows the worksheet name to be shown in a cell. For example, say the worksheet name is "Totals", is it possible to have this display in one of the cells without having to type it in.
 
This formula should work once the file has been saved --

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

Rgds,
Andy
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Linking Tab/worksheet names to a worksheet cell 3
Worksheet tab name 12
Tie additional cells to cell automatically updated 1
Name a worksheet tab based on the value in a cell. 1
Use worksheet name in one cell as part of reference in other cells 3
Worksheet (tab names) in cells 3
Excel VBA 1

Back
Top