• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 306
  • Last Modified:

get a cell to reflect a tab name

I want to have a certain cell show the tab name in a worksheet with multiple tabs - so when I am in the worksheet with a tab named Shelley - Shelley also shows up in cell B4
0
Dier02
Asked:
Dier02
1 Solution
 
roger_karamCommented:
Hello,

Try this, where A1 is any non-error cell:

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

from:
http://www.ozgrid.com/VBA/return-sheet-name.htm

-RK
0
 
zorvek (Kevin Jones)ConsultantCommented:
The formula below returns the sheet or tab name on which the formula resides.

   =MID(CELL("filename",A1),SEARCH("]",CELL("filename"))+1,31)

Kevin
0
 
Dier02Author Commented:
Thanks Kevin, great work.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now