NamedRange.Dirty Method (2007 System)
Designates the NamedRange control to be recalculated when the next recalculation occurs.
Namespace: Microsoft.Office.Tools.Excel
Assembly: Microsoft.Office.Tools.Excel.v9.0 (in Microsoft.Office.Tools.Excel.v9.0.dll)
Syntax
'Declaration
Public Sub Dirty
'Usage
Dim instance As NamedRange
instance.Dirty()
public void Dirty()
public:
void Dirty()
public function Dirty()
Remarks
The Calculate method forces the NamedRange control to be recalculated, for cells that Microsoft Office Excel understands as needing recalculation.
If the application is in manual calculation mode, using the Dirty method instructs Excel to identify the NamedRange control to be recalculated. If the application is in automatic calculation mode, using the Dirty method instructs Excel to perform a recalculation.
.NET Framework Security
- Full trust for the immediate caller. This member cannot be used by partially trusted code. For more information, see Using Libraries from Partially Trusted Code.