G Guest Jul 6, 2007 #1 Is this an option? I want a cell on a worksheet to reference (copy) the sheet tab name. Excel (Office 2003)
Is this an option? I want a cell on a worksheet to reference (copy) the sheet tab name. Excel (Office 2003)
P Peo Sjoblom Jul 6, 2007 #2 The workbook needs to be saved =MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,32) You can put this in any cell, the formula needs a cell reference that is what A1 does but it can be any cell -- Regards, Peo Sjoblom Excel 95 - Excel 2007 Northwest Excel Solutions www.nwexcelsolutions.com (Remove ^^ from email)
The workbook needs to be saved =MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,32) You can put this in any cell, the formula needs a cell reference that is what A1 does but it can be any cell -- Regards, Peo Sjoblom Excel 95 - Excel 2007 Northwest Excel Solutions www.nwexcelsolutions.com (Remove ^^ from email)
