Dynamic Size Arrays | VBAReference

CitectVBA Programming Reference > Understanding CitectVBA Language Basics > Variables > Dynamic Size Arrays

Dynamic Size Arrays

To declare a dynamic sized array, the array must first be declared using the dim statement with an empty pair of parentheses following the array name. For example:

Dim ArrayName( ) As Integer

Once declared as dynamic in this manner, the array can then ONLY be resized within a function or subroutine using the redim statement.

ReDim ArrayName(20) As Integer

Note: You cannot resize an array whose size was predefined in its initial declaration.

In the above examples, the first declaration creates an array with 0 elements. The second recreates the array to contain 21 elements, with index numbers running from 0 to 20, unless the option base statement has been set previously in the code module (file), in which case the array will contain 20 elements with index numbering ranging from 1 to 21.

Unless specifically defined in the array declaration statement, default lower bound settings are used. The default lower bound is zero, unless set by the module option base statement setting. For more information on bounds, see "Array Subscripts in CitectVBA."

Redim erases all values the array may have held. To preserve the contents of the array when resizing, precede the Redim statement with the preserve keyword.

Preserve ReDim ArrayName(20) As Integer

Redimensioning an array to a smaller value, will erase any values it may have contained in the removed portions.

Arrays declared (using the dim statement within procedures,) do not retain their values between procedure calls in CitectVBA.