MakeArray
Returns an array containing the values that are passed to the function.
Syntax
MakeArray([<value>[,<value>]...])
Parameters
<value>
Type: None
A comma-delimited list of values to be returned as an array.
(return)
Type: Array
A single dimension array containing the values that are specified in [<value>[,<value>]...].
Notes
The arguments can be of data type. All of the arguments passed to the function are returned as a single dimension array. If no arguments are specified, an empty array is returned.
Example
This example uses MakeArray function call the ADO Recordset AddNew method, which takes an array of column names and an array of values.
adoRS.AddNew(MakeArray("Age", "Gender", "Address"), _
MakeArray(47, {Male}, "79 Alpha Ave"))
See also