Share via


ErrorCheckingOptions.InconsistentFormula Property

When set to True (default), Microsoft Excel identifies cells containing an inconsistent formula in a region. False disables the inconsistent formula check.

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

Syntax

'Declaration
Property InconsistentFormula As Boolean
    Get
    Set
'Usage
Dim instance As ErrorCheckingOptions
Dim value As Boolean

value = instance.InconsistentFormula

instance.InconsistentFormula = value
bool InconsistentFormula { get; set; }

Property Value

Type: System.Boolean

Remarks

Consistent formulas in the region must reside to the left and right or above and below the cell containing the inconsistent formula for the InconsistentFormula property to work properly.

See Also

Reference

ErrorCheckingOptions Interface

ErrorCheckingOptions Members

Microsoft.Office.Interop.Excel Namespace