Is there a way in excel 2000 to make a cell automatically change based on the
worksheet name tab?

Thanks,
Steve

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

See http://www.xldynamic.com/source/xld.xlFAQ0002.html

--
HTH

Bob Phillips

"Steve" wrote in message
...
Is there a way in excel 2000 to make a cell automatically change based on
the
worksheet name tab?

Thanks,
Steve