Excel 2000

[ritaknowles]

I want to be able to return the tabbed worksheet name into
a cell ie I want a cell to automatically pick up the name
of the worksheet the cell is in.
Is there a way of doing this?
Thanks.

 

[J.E. McGimpsey]

one way (file must be saved):

=MID(CELL("filename",A1), FIND("]", CELL("filename",A1))+1, 255)

 

[Peo Sjoblom]

If the workbook is saved this will work

=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,32)

 

[Guest]

It works a treat even though I have not understood the
logic yet.
Thank you both.
rita

-----Original Message-----
one way (file must be saved):

=MID(CELL("filename",A1), FIND("]", CELL ("filename",A1))+1, 255)

I want to be able to return the tabbed worksheet name into
a cell ie I want a cell to automatically pick up the name
of the worksheet the cell is in.
Is there a way of doing this?
Thanks.

.