I have to use the function on 10 defferent sheets so I placed the code in a
added module - I think that's what you'r poiting out - but still I get run
time error 424

"Niek Otten" wrote:

Do you put the code in a General Module? It should not be in a Sheet module. I didn't get the error.

--
Kind regards,

Niek Otten

"KSO" <keld DOT soerensen@os DOT dk wrote in message ...
Hi Niek

It won't work either - I get runtime error 424

But I can see it's NOT a safe metode.

KS, Denmark

"Niek Otten" wrote:

That is not a safe way to get the name of the sheet where the formula is; some other sheet might be active.

Use

Function SheetName() As String
SheetName = Application.Caller.SheetName
End Function


--
Kind regards,

Niek Otten

"KSO" <keld DOT soerensen@os DOT dk wrote in message ...
I have defined a function like

Function GetSheetName() as String
Application.Volatile ' I tried this but no difference
GetSheetName=ActiveSheet.Name
End func

and when I use it in a cell on a workheet - then
sometimes it works and sometimes it won't - why ?

KS, Denmark