_Application.ThisCell Property
Returns the cell the user-defined function is being called from as a Range object.
Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)
Syntax
'Declaration
ReadOnly Property ThisCell As Range
Get
'Usage
Dim instance As _Application
Dim value As Range
value = instance.ThisCell
Range ThisCell { get; }
Property Value
Type: Microsoft.Office.Interop.Excel.Range
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.