Name cell after worksheet Tab
 

Is there anyway to make the name of a tab appear in a cell.
Thank you


--
thetoppy
------------------------------------------------------------------------
thetoppy's Profile: http://www.excelforum.com/member.php...o&userid=33436
View this thread: http://www.excelforum.com/showthread...hreadid=532891

Name cell after worksheet Tab
 

Hello
Enter this formula into a cell:
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,20)

Please note: Workbook must be saved

HTH
Cordially
Pascal

"thetoppy" a écrit
dans le message de news:
...

Is there anyway to make the name of a tab appear in a cell.
Thank you


--
thetoppy
------------------------------------------------------------------------
thetoppy's Profile:
http://www.excelforum.com/member.php...o&userid=33436
View this thread: http://www.excelforum.com/showthread...hreadid=532891

Name cell after worksheet Tab
 

Thank you so much


--
thetoppy
------------------------------------------------------------------------
thetoppy's Profile: http://www.excelforum.com/member.php...o&userid=33436
View this thread: http://www.excelforum.com/showthread...hreadid=532891