Maybe someting like this:

"------------------------------
Function sheetname(rng As Range) As String
sheetname = rng.Worksheet.Name
End Function
'------------------------------

HTH
--
AP

"EXCEL$B!!(BNEWS" <youngmanca@hotmail.com> a ecrit dans le message de
news:OJZtb$FYGHA.3532@TK2MSFTNGP05.phx.gbl...
> here is my function
>
> Function SheetName(x) As String '
> Application.Volatile
> SheetName = ActiveSheet.name
> End Function '
>
> what i want to do is to get the sheet name in in which a cell (like
> =SheetName(0)) is in.
>
> not the. name of ActiveSheet.
>
> what should i do.
>
>
>
>
>