Array as Parameter in Function Excel VBA

In Today's Video, We will create a function and ParamArray will be pass as argument in same. The ParamArray argument makes it possible for a function to accept an arbitrary(random) number of arguments, each of a possibly different type.The ParamArray keyword allows you to accept a dynamic number of arguments. While using ParamArray we need to be informed for below: The parameter array must be defined with a Variant datatype only. The ParamArray is always zero based and it is not effected by the Option Base statement.Option Base 1 statement is used to shift the base of Array from 0 to 1. ParamArray should be the last argument in the list and it cannot be used in the same argument list as an Optional argument. This can only be used as the last argument in a procedure or function This keyword allows you to provide an arbitrary number of arguments that get submitted as an array. For Entire Playlist:    • First Macro Excel VBA