ReDim
ReDim [Preserve] nameA[([subscriptA[, subscriptB[,
- subscriptC...]]])][, nameB...[, nameC...[...]]]
Description
ReDim is used to reallocate storage space for fixed arrays. The required component, name, is the name of the variable, and it must follow standard variable naming conventions. The optional list of subscript arguments are the dimensions of an array variable, up to 60 comma separated, numeric expressions can be used. The optional keyword, Preserve will preserve data in an existing array, when only the size of the last dimension is changed. The lower bound of an array is always 0.
Example
Rem ReDim Example 'ReDim reallocates array storage 'An empty variable named "Foo" Dim Foo 'A one-dimensional array with 10 elements ReDim Foo(9) 'A two-dimensional array with 600 elements '20 x 30 ReDim Foo(19, 29)