Can one "access" the worksheet name into a cell reference, or vice-versa (Excel 2000)? TiA!
D DOC Oct 16, 2003 #1 Can one "access" the worksheet name into a cell reference, or vice-versa (Excel 2000)? TiA!
P Peo Sjoblom Oct 16, 2003 #2 If the workbook is saved this will work =MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,32) you can put it in any cell
If the workbook is saved this will work =MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,32) you can put it in any cell
