Thank you! Thank you! Thank you!

Cindi
-----Original Message-----
Put in say, A1*:

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

(This'll extract the sheetname into A1.
But you need to save the file first)

*can be any cell in the sheet

--
Rgds
Max
xl 97
---
GMT+8, 1=B0 22' N 103=B0 45' E
xdemechanik <atyahoo<dotcom
----
cindi wrote in=20
message
...
Can I create a formula in a cell that will equal the
sheet tab name?

Thanks,

Cindi


.