Lists values used to specify the type of cell errors.
The specified intersection includes two ranges that do not intersect. This error is indicated as #NULL!.
The formula includes division by zero or by a cell that does not contain any data. This error is indicated as #DIV/0!.
The formula includes a value of the wrong data type. This error is indicated as #VALUE!.
The formula includes an invalid cell reference. This error is indicated as #REF!.
The formula includes text that is not recognized (for example, a function name that is spelled incorrectly, a cell range reference without colon, etc.). This error is indicated as #NAME?.
The formula or function includes invalid numeric values. This error is indicated as #NUM!.
The value is not available to the formula or function. This error is indicated as #N/A.
Related API Members
The following properties accept/return XlCellErrorType values:
The values listed by this enumeration are returned by the IXlCellError.Type property.