ThisCell Property

Returns the cell in which the user-defined function is being called from as a Range object.

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