View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default 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.