Application.ThisCell Property (Excel)

Office 2013 and later
GitHub-Mark-64px

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: " & _ 
 Application.ThisCell.Address 
End Function
Show: