Cell = Tab Name

  • Thread starter Thread starter Benjamin
  • Start date Start date
Benjamin said:
How can I get a cell to equal the Tab Name?
Click to expand...

Click Insert > Name > Define
Put under "Names in workbook:": WSN
Put in the "Refers to:" box:
=MID(CELL("Filename",INDIRECT("A1")),FIND("]",CELL("Filename",INDIRECT("A1")
))+1,32)
Click OK

The above defines WSN as a name we can use to refer to the sheetname in
formulas. It will auto-extract the sheetname implicitly. Technique came from
a post by Harlan. The book must be saved first.

Test it out:
In any sheet, in any cell, put: =WSN,
and that cell will return the sheet's name

---
 
I assume that by "Tab Name" you mean worksheet name?

=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,
LEN(CELL("filename",A1))-FIND("]",CELL("filename",A1)))
 
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

Copy a cell from a diferent tab when the tab name is in a cell 2
Tab color change 2
Tab Names 2
Is it possible to set tabs within an excel cell? 2
Macro: finding a cell on one worksheet and copying to another worksheet 0
Copying data from cells A1,B1,C1 on tab1 to tab2 1
Reference every 13th cell from another tab. 6
IF Then 4

Back
Top