G Guest Aug 19, 2005 #2 DRHannay said: how do I place the sheet tab name in my spreadsheet by formula? Excel 2003 Click to expand... Try: =MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255)
DRHannay said: how do I place the sheet tab name in my spreadsheet by formula? Excel 2003 Click to expand... Try: =MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255)
B Blue Hornet Aug 19, 2005 #3 Alternatively, you could write a one-line function in VBA to do the same thing, easier: Function SheetName() SheetName = ActiveSheet.Name End Function If this is stored in Personal.XLS where it is always available, you'd call it on your worksheet with: =PERSONAL.XLS!sheetname() Otherwise, if it's stored in the current Workbook (or in an Add-in which you enable), you could call it without the reference to Personal.XLS Chris
Alternatively, you could write a one-line function in VBA to do the same thing, easier: Function SheetName() SheetName = ActiveSheet.Name End Function If this is stored in Personal.XLS where it is always available, you'd call it on your worksheet with: =PERSONAL.XLS!sheetname() Otherwise, if it's stored in the current Workbook (or in an Add-in which you enable), you could call it without the reference to Personal.XLS Chris
G Guest Aug 2, 2006 #4 Hello, What would be the formula to add in filename into my spreadsheet? Paul Moles said: DRHannay said: how do I place the sheet tab name in my spreadsheet by formula? Excel 2003 Click to expand... Try: =MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255) Click to expand...
Hello, What would be the formula to add in filename into my spreadsheet? Paul Moles said: DRHannay said: how do I place the sheet tab name in my spreadsheet by formula? Excel 2003 Click to expand... Try: =MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255) Click to expand...
