Array as Parameter in Function Excel VBA

Published: 22 December 2018
on channel: ByteWise

5,394

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

On this page of the site you can watch the video online Array as Parameter in Function Excel VBA with a duration of hours minute second in good quality, which was uploaded by the user ByteWise 22 December 2018, share the link with friends and acquaintances, this video has already been watched 5,394 times on youtube and it was liked by 58 viewers. Enjoy your viewing!

13,912

323