Application.ThisCell Property (Excel)

Office 2013 and later

Contribute to this content

Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation.

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

expression .ThisCell

expression A variable that represents an Application object.

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.

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: " & _ 
End Function