Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Excel: Putting the name of the sheet in a cell without Macros
You are right Skip, I was not aware of xlbo's thread. Hopefully though, this thread will help other people finding the "right" formula/solution.- mikemmd
- Post #3
- Forum: Microsoft: Office
-
Excel: Putting the name of the sheet in a cell without Macros
What? If a sheet is called "my tab 1", I wand the cell (eg) A1 to have "my tab 1" in it. How? Simply enter: =MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,30) Changing the tab's name to "my tab 2" changes the value of A1 to "my tab 2" automatically. Et voila! Caution: a lot of...- mikemmd
- Thread
- Replies: 3
- Forum: Microsoft: Office
