OmittedCells Property
Important This document may not represent best practices for current development, links to downloads and other resources may no longer be valid. Current recommended version can be found here. ArchiveDisclaimer

ErrorCheckingOptions.OmittedCells Property 

When set to True (default), Microsoft Excel identifies, with an AutoCorrect Options button, the selected cells that contain formulas referring to a range that omits adjacent cells that could be included. False disables error checking for omitted cells.

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

Dim errorCheckingOptions1 As ErrorCheckingOptions

Dim returnValue As Boolean
returnValue = errorCheckingOptions1.OmittedCells

Dim sampleValue As Boolean
errorCheckingOptions1.OmittedCells = sampleValue

bool OmittedCells {get; set;}
public boolean get_OmittedCells();
public void set_OmittedCells(boolean);
function get OmittedCells() : Boolean;
function set OmittedCells(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

© 2016 Microsoft