I'm not sure what the variable "x" is for in your example.
But try this:

Function SHEETNAME() As String
Dim s As Object
Application.Volatile
Set s = Application.Caller
SHEETNAME = s.Parent.Name
End Function

You type in a cell:
=SHEETNAME()

The formula will return the sheetname of the sheet where you typed the
formula.

Regards,
Edwin Tam
edwintam@vonixx.com
http://www.vonixx.com


"EXCEL　NEWS" wrote:

> 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.
>
>
>
>
>
>