referencing worksheet names in a cell

S

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

=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.
 
Top