Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

get a cell to reflect a tab name

Posted on 2011-02-23
3
263 Views
Last Modified: 2012-05-11
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
Comment
Question by:Dier02
3 Comments
 
LVL 5

Expert Comment

by:roger_karam
ID: 34959406
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
 
LVL 81

Accepted Solution

by:
zorvek (Kevin Jones) earned 500 total points
ID: 34959408
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
 

Author Closing Comment

by:Dier02
ID: 34959562
Thanks Kevin, great work.
0

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.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Introduction This Article is a follow-up to my Mappit! Addin Article (http://www.experts-exchange.com/A_2613.html), it was inspired by an email posting I made to EUSPRIG (http://www.eusprig.org/index.htm), I will briefly cover: 1) An overvie…
Introduction While answering a recent question (http:/Q_27311462.html), I created an alternative function to the Excel Concatenate() function that you might find useful.  I tested several solutions and share the results in this article as well as t…
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

840 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question