The following data types are supported for input arguments:
Simple data types can be marked as being Scalar, Vector or Matrix inputs.
Grouped arguments contain multiple inputs wrapped into a single Excel argument. This is useful when there are a large number of inputs (Excel add-in functions are limited to at most 29 arguments) or when multiple columns can usefully be grouped into a single aligned matrix.
See Grouping arguments in the User Guide for more information about grouped arguments.
These are native Excel types, represented respectively in the add-in function as CXlArray, COper and CXlOper objects. The Wizard will generate code to instantiate the objects in your function, but will not do anything further with them.
See also Comparison of COper, CXlOper and CXlArray in the Reference for more about these types.