worksheet name in cell

[imillar]

is there a way to insert the worksheet name into a cell
EG:
sheet 1 name is "John"
sheet 2 name is "brian"

on another worksheet "summary" i want to insert these two worksheet names in cells a1 and a2.

regards

[Andrew70]

I don't know if this is the easiest way, but this formula seems to work:

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

(Change the 20 at the end of the formula to the maximum length you expect the sheet name might be.)

[Staticman]

=RIGHT(CELL("Filename"),LEN(CELL("filename"))-SEARCH("]",CELL("filename")))
and another

Dave

[imillar]

these work, but what i would really like to do is be able to drag down so it finds the next worksheet name, and the next, etc.....
i have 26 sheets in total

[SamS]

On 2002-04-09 04:42, imillar wrote:
these work, but what i would really like to do is be able to drag down so it finds the next worksheet name, and the next, etc.....
i have 26 sheets in total

Some other answers here which may assist you.
http://www.mrexcel.com/board/viewtop...c=3816&forum=2