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