This documentation is archived and is not being maintained.

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

Dim errorCheckingOptions1 As ErrorCheckingOptions

Dim returnValue As Boolean
returnValue = errorCheckingOptions1.InconsistentFormula

Dim sampleValue As Boolean
errorCheckingOptions1.InconsistentFormula = sampleValue

bool InconsistentFormula {get; set;}
public boolean get_InconsistentFormula();
public void set_InconsistentFormula(boolean);
function get InconsistentFormula() : Boolean;
function set InconsistentFormula(Boolean);

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.

Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Development Platforms

Windows XP Home Edition, Windows XP Professional, Windows Server 2003, and Windows 2000

Target Platforms