This UDF will do it

Function MySheet()
Application.Volatile
MySheet = ActiveSheet.Name
End Function

Call it with =mysheet()
best wishes

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"dminkov" wrote in
message ...

Hi everyone!

Is it possible to write a formula, which returns the name of the
worksheet as a value of the cell?

Waiting for your comments,

Dobrin


--
dminkov
------------------------------------------------------------------------
dminkov's Profile:
http://www.excelforum.com/member.php...o&userid=17757
View this thread: http://www.excelforum.com/showthread...hreadid=557305