MakeArray
Returns an array containing the values that are passed to the function.
Syntax
MakeArray([Val[,Val]...])
Parameters
Vals
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 [Val[,Val]...].
Remarks
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