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


In VBA, just:
MsgBox(ActiveSheet.Name)
--
Gary''s Student - gsnu200905


"xp" wrote:

Is there a formula that will return the current sheet name?

like: =Cell("Sheetname")

Thanks in advance!