Function that returns worksheet name?
How about a single line UDF:
Function wsheetname()
wsheetname = Application.Caller.Parent.Name
End Function
--
Gary's Student
" wrote:
Is there an Excel function that returns the name of the worksheet that
contains this formula?
I thought it might be part of cell("address"), which I could parse.
But that seems to be true only if the cell is in another worksheet.
|