ThisCell Property
Returns the cell in which the user-defined function is being called from as a Range object.
expression.ThisCell
expression Required. An expression that returns one of the objects in the Applies To list.
Remarks
Users should not access properties or methods on the Range object when inside the user-defined function. Users can cache the Range object for later use and perform additional actions when the recalculation is finished.
Example
In this example, a function called "UseThisCell" contains the ThisCell property to notify the user of the cell address.
Function UseThisCell()
MsgBox "The cell address is: " & _
Application.ThisCell.Address
End Function