Excel 2000

  • Thread starter Thread starter ritaknowles
  • Start date Start date
R

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.
 
one way (file must be saved):

=MID(CELL("filename",A1), FIND("]", CELL("filename",A1))+1, 255)
 
If the workbook is saved this will work

=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,32)
 
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.
Click to expand...
.
Click to expand...
 
Back
Top