The set of error values that can be displayed in Excel.
enum XlErrorType |
The XlErrorType enumeration lists the values that are used to indicate error results in Excel.
| xlerrValue | 15 | #VALUE! Occurs when the wrong type of argument or operand is used. |
| xlerrDiv0 | 7 | #DIV/0! Occurs when a number is divided by zero (0). |
| xlerrName | 29 | #NAME? Occurs when Microsoft Excel doesn't recognize text in a formula. |
| xlerrNA | 42 | #N/A Occurs when a value is not available to a function or formula. |
| xlerrRef | 23 | #REF! Occurs when a cell reference is not valid. |
| xlerrNum | 36 | #NUM! Occurs with invalid numeric values in a formula or function. |
| xlerrNull | 0 | #NULL! Occurs when you specify an intersection of two areas that do not intersect. The intersection operator is a space between references. |
Header: xllplus.h