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.

See

http://www.mcgimpsey.com/excel/formu..._function.html

In article .com,
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.

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.

JE McGimpsey wrote:
See http://www.mcgimpsey.com/excel/formu..._function.html

Thanks! Funny, I was gonna try cell("filename"), but I let "logic" get
the better of me ("nah, filename has nothing to do with worksheet name,
which, after all, is just an object within the file"). I need to
remind myself to "throw caution to the wind" ;-).

That does require that I save the workbook first. But I can live with
that. Thanks again.

Sub sheetname()
Range("d1").Value = Application.ActiveSheet.Name
End Sub

Vaya con Dios,
Chuck, CABGx3




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