Note that this requires that the workbook has been saved at least once
(rather than being a new workbook with a default name like Book1 as an
example).

--
Regards,
Tom Ogilvy

"Frank Kabel" wrote in message
...
Hi
To get the current worksheet name try:
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255)

--
Regards
Frank Kabel
Frankfurt, Germany

hans wrote:
Does anyone know hot to make a function that returns the name of the
curred sheet as a string

I would like to have something like

="You are on sheet" & sheetname()

Greetings Hans