how to make a particular cell assume the name of the worksheet

Originally Posted by kelsnjoku

=MID(CELL("filename",$A$1),FIND("]",CELL
("filename",$A$1))+1,LEN(CELL("filename",$A
$1))-FIND("]",CELL("filename",$A$1)))

This formular worked.

Btw, how did you come up with that lengthy formula

the one that I'd prepared earlier