S Stacey Snyder Sep 25, 2003 #1 I'd like to know a formula to put in A1 of sheet 1 that returns me the name of Sheet 2. Thanks, Stacey Snyder
I'd like to know a formula to put in A1 of sheet 1 that returns me the name of Sheet 2. Thanks, Stacey Snyder
J J.E. McGimpsey Sep 25, 2003 #2 =MID(CELL("filename",'Sheet2'!A1), FIND("]", CELL("filename",'Sheet2'!A1))+1, 255) Replace Sheet2 with the current name of your sheet2, the formula will then update if you rename sheet2.
=MID(CELL("filename",'Sheet2'!A1), FIND("]", CELL("filename",'Sheet2'!A1))+1, 255) Replace Sheet2 with the current name of your sheet2, the formula will then update if you rename sheet2.
