Can the =CELL formula be used to determine the worksheet tab name.
The tab is named '522' and I want '522' to show up in a cell in the worksheet
such as A1. I know that =CELL can be used to get the filenam, but can it be used to get the tab name? If not, is there another function that will? |
Check out
http://www.mcgimpsey.com/excel/formu..._function.html In article , "Hawk186" wrote: The tab is named '522' and I want '522' to show up in a cell in the worksheet such as A1. I know that =CELL can be used to get the filenam, but can it be used to get the tab name? If not, is there another function that will? |
You can also use a UDF for this. The CELL function has a known bug (not
sure if MS fixed it or not); generally it will work just fine though. An example of a worskheet function (UDF) that will accomplish this canbe found he http://www.vbaexpress.com/kb/getarticle.php?kb_id=401 HTH -- Regards, Zack Barresse, aka firefytr "Hawk186" wrote in message ... The tab is named '522' and I want '522' to show up in a cell in the worksheet such as A1. I know that =CELL can be used to get the filenam, but can it be used to get the tab name? If not, is there another function that will? |
Did you ever get a specific answer to your question? I'm looking for the
same info. "Hawk186" wrote: The tab is named '522' and I want '522' to show up in a cell in the worksheet such as A1. I know that =CELL can be used to get the filenam, but can it be used to get the tab name? If not, is there another function that will? |
I think you can use this: =MID(CELL("filename",A1), FIND("]", CELL("filename", A1))+ 1, 255) -- gwexcel ------------------------------------------------------------------------ gwexcel's Profile: http://www.excelforum.com/member.php...fo&userid=6845 View this thread: http://www.excelforum.com/showthread...hreadid=366070 |
All times are GMT +1. The time now is 10:01 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com