Steve,
Copy this and put it in the cell where you want the name
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255)
Note it will not work in a new workbook, untill it has been saved.
This help?
Dave
Steve Wrote:
Is there a way in excel 2000 to make a cell automatically change based
on the
worksheet name tab?
Thanks,
Steve
--
Piranha
------------------------------------------------------------------------
Piranha's Profile:
http://www.excelforum.com/member.php...o&userid=20435
View this thread:
http://www.excelforum.com/showthread...hreadid=390461