VBA: Optional parameters

The keyword optional declares a function/sub parameter to be optional.

The function isMissing can be used to check if a value was specified for an optional parameter.

The keyword paramArray allows to pass an aribtrary number of arguments to a sub or function.