Error value types
Below is a list of error values that can be returned to Excel
as the value of a CXlOper.
||The function's logic requires an intersection of two areas that do not intersect
||Divide by zero
||Argument is of the wrong type and cannot be coerced to the right type
||A cell reference is not valid
||A range name is not valid
||The #NUM! error value occurs when a problem occurs with a number in a formula or function.
A typical use is for numeric inputs that are out of range.
||Data is not currently available
Below is a list of result codes that can be returned by
and all methods of CXlMacros
||The function call was successful.
This is not always proof of complete success; in some cases the values
returned by the call will need to be inspected: they may contain error types (see above).
||The function call was interrupted by the user.
||The function was not valid or was not valid at this time.
||The wrong number of arguments was passed.
||One of the arguments was invalid.
||Occurs when a call to the Excel SDK API resulted in stack overflow, often as a result of recursion.
||Occurs when a call to the Excel SDK API failed, often because the API is not available at this time.
||Occurs as a result of a call to the Excel SDK API, when one of the inputs to the function was an uncalculated cell. An add-in function should return immediately; it will be called again later, when the cell has been calculated.