Cell display worksheet title
How can I make a cell display the title of a worksheet, so that when I change
the name on a worksheet tab, the cell changes with it? |
Cell display worksheet title
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,32)
will give you the sheet name, the workbook needs to be saved before this formula works correctly -- Regards, Peo Sjoblom Excel 95 - Excel 2007 Northwest Excel Solutions www.nwexcelsolutions.com (Remove ^^ from email) "Jim Marchiori" <Jim wrote in message ... How can I make a cell display the title of a worksheet, so that when I change the name on a worksheet tab, the cell changes with it? |
All times are GMT +1. The time now is 11:50 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com