Share via

ErrorCheckingOptions.OmittedCells Property

  • Article
Excel Developer Reference

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.

Visual Basic for Applications 
  Sub CheckOmittedCells()

Application.ErrorCheckingOptions.<strong class="bterm">OmittedCells</strong> = True
Range("A1").Value = 1
Range("A2").Value = 2
Range("A3").Value = 3
Range("A4").Formula = "=Sum(A1:A2)"



End Sub

See Also