NamedRange.Dirty Method

Designates the NamedRange control to be recalculated when the next recalculation occurs.

Namespace:  Microsoft.Office.Tools.Excel
Assembly:  Microsoft.Office.Tools.Excel (in Microsoft.Office.Tools.Excel.dll)

Syntax

'Declaration
Sub Dirty
void 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

See Also

Reference

NamedRange Interface

Microsoft.Office.Tools.Excel Namespace