Functions (VBScript)


Visual Basic Scripting Edition
Array Function

Updated: April 2009

Returns a Variant containing an array.

Array(arglist)
Remarks

The required arglist argument is a comma-delimited list of values that are assigned to the elements of an array contained with the Variant. If no arguments are specified, an array of zero length is created.

The notation used to refer to an element of an array consists of the variable name followed by parentheses containing an index number indicating the desired element.

All arrays in Visual Basic Scripting Edition (VBScript) are zero-based.

The Array function is used to create single-dimension arrays. For information about multi-dimensional arrays, see VBScript Variables.

NoteNote:

A variable that is not declared as an array can still contain an array. Although a Variant variable containing an array is conceptually different from an array variable containing Variant elements, the array elements are accessed in the same way.

Example

The following example illustrates the use of the Array function.

' Create a single-dimension array and assign three elements.
Dim A
A = Array(10,20,30)
' Set B to the third element in the array (which is 30).
' The array is zero-based.
B = A(2)
Requirements

Version 2

See Also

Reference

Change History

Date

History

Reason

April 2009

Added information to remarks and added comments to the example.

Customer feedback.

Tags : array function


Community Content

QazzLand
Array Object Needs Redesigning!

There needs to be a better set of tools to work with the array object; if the Array is empty, functions such as UBound and LBound will only throw exception errors, and there is not a lot in the way of tests that can trap this error--and besides, LBound is a pointless functions since it ALWAYS returns 0, unless the array is actually empty, in which case it throws an exception.

isNull(array)


won't work because if the array has been defined, it won't be Null. Further, trying to determine the emptiness of an array is not exactly graceful, either, since its use in any formula throws an exception.

What's really needed is something along the order of a "size" function that returns how many elements are in the array, specifically 0 (zero) if there are no elements--without throwing up an exception error.

This has been an issue for as long as there have been vb arrays...It's really time to fix this shortcoming!


Page view tracker