This documentation is archived and is not being maintained.

ErrorCheckingOptions.EmptyCellReferences Property 

When set to True (default), Microsoft Excel identifies, with an AutoCorrect Options button, selected cells containing formulas that refer to empty cells. False disables empty cell reference checking.

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

Dim errorCheckingOptions1 As ErrorCheckingOptions

Dim returnValue As Boolean
returnValue = errorCheckingOptions1.EmptyCellReferences

Dim sampleValue As Boolean
errorCheckingOptions1.EmptyCellReferences = sampleValue

bool EmptyCellReferences {get; set;}
public boolean get_EmptyCellReferences();
public void set_EmptyCellReferences(boolean);
function get EmptyCellReferences() : Boolean;
function set EmptyCellReferences(Boolean);

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