cell = tab

S

Steve

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

Thanks,
Steve
 
P

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?
 
Top