Application

Global Methods and Properties

The following methods and properties of the Application object are global and therefore can be used without the Application prefix.

Application.ActiveCell 
ActiveCell 

This list can be obtained from the top list of classes in the Object Browser.

Application.Caller

The Caller property of the Application object returns a reference to the object that called (or executed a macro procedure).
This property applies to controls on the Forms toolbar and drawing objects that have macros attached.
It is also particularly useful in determining the cell that called a user defined function.

Public Function WorksheetName() As String 
   Application.Volatile = True 
   WorksheetName = Application.Caller.Parent.Name 
End Function 

You cannot use "ActiveSheet.Name" in case the calculation is invoked when a different worksheet is selected.