G Guest Aug 23, 2006 #1 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?
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?
P Peo Sjoblom Aug 23, 2006 #2 =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)
=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)
