MBS( "XL.Sheet.AddIgnoredError"; /* Adds the ignored error for specified range. */$bookRef; /* The reference to the workbook. Please use XL.LoadBook to load a file.e.g. $ref */
$sheetIndex; /* The index of the sheet. This number ranges from 0 to XL.Book.SheetCount-1.e.g. 0 */
$rowFirst; /* The first row for the area. First row has index 0.e.g. $row */
$colFirst; /* The first column for the area. First column has index 0.e.g. $column */
$rowLast; /* The last row for the area. First row has index 0.e.g. $row */
$colLast; /* The last column for the area. First column has index 0.e.g. $column */
$ignoreErrors) /* The combination of errors to ignore.e.g. "InconsistRange¶EvalError" */
Less

Result

Returns OK or error.

Description

Adds the ignored error for specified range.
It allows to hide green triangles on left sides of cells. For example, if a cell is formatted as text but contains a numeric value, this is considered to be a potential error because the number won't be treated as a number, for example, in calculations. It is possible to combine a few IgnoredError values as list.
Returns error message on failure.

IgnoredError value

Description

NoError

No errors

EvalError

Ignore errors when cells contain formulas that result in an error.

EmptyCellRef

Ignore errors when formulas refer to empty cells.

NumberStoredAsText

Ignore errors when numbers are formatted as text or are preceded by an apostrophe.

InconsistRange

Ignore errors when formulas omit certain cells in a region.

InconsistFormula

Ignore errors when a formula in a region of your worksheet differs from other formulas in the same region.