Excel.ErrorCheckingOptions.OmittedCells.md

title	keywords	f1_keywords	api_name	ms.assetid	ms.date	ms.localizationpriority
ErrorCheckingOptions.OmittedCells property (Excel)	vbaxl10.chm698079	vbaxl10.chm698079	Excel.ErrorCheckingOptions.OmittedCells	a337da5d-4f02-d24c-c59a-288b4a9c9117	04/26/2019	medium

ErrorCheckingOptions.OmittedCells property (Excel)

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. Read/write Boolean.

Syntax

expression.OmittedCells

expression A variable that represents an ErrorCheckingOptions object.

Example

In the following example, the AutoCorrect Options button appears for cell A4, which contains a formula.

Sub CheckOmittedCells() 
 
 Application.ErrorCheckingOptions.OmittedCells = True 
 Range("A1").Value = 1 
 Range("A2").Value = 2 
 Range("A3").Value = 3 
 Range("A4").Formula = "=Sum(A1:A2)" 
 
End Sub

[!includeSupport and feedback]