cell = tab

[Guest]

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

Thanks,
Steve

 

[Piranha]

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?

 

[Bob Phillips]

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