Put in say, A1*:

=MID(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° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
cindi wrote in message
...
Can I create a formula in a cell that will equal the
sheet tab name?

Thanks,

Cindi