Thanks for the help.

Greeetings Hans


"Gord Dibben" <gorddibbATshawDOTca schreef in bericht
...
Hans

Programming method.

Function SheetName(Optional ByVal rng As Range) As String
Application.Volatile
If rng Is Nothing Then Set rng = Application.Caller
SheetName = rng.Parent.Name
End Function

Gord Dibben Excel MVP

On Mon, 16 Feb 2004 17:04:00 +0100, "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