ErrorCheckingOptions.OmittedCells Property (Excel)

Office 2013 and later
GitHub-Mark-64px

Contribute to this content

Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation.

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.

expression .OmittedCells

expression A variable that represents an ErrorCheckingOptions object.

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
Show: