J John Wilson Dec 9, 2003 #2 "A", Try this (in any cell on the worksheet): =MID(CELL("filename",A1), FIND("]", CELL("filename",A1))+1, 255) John
"A", Try this (in any cell on the worksheet): =MID(CELL("filename",A1), FIND("]", CELL("filename",A1))+1, 255) John
R Ron Rosenfeld Dec 9, 2003 #3 Anybody know how to get the name of worksheet in cell? Thanks Click to expand... One way: =MID(CELL("filename"),FIND("]",CELL("filename"))+1,255) will work after the workbook has been saved. --ron
Anybody know how to get the name of worksheet in cell? Thanks Click to expand... One way: =MID(CELL("filename"),FIND("]",CELL("filename"))+1,255) will work after the workbook has been saved. --ron
