Description

 

Used to re dimension a previously declared arrays.

 

Syntax

 

REDIM [PRESERVE] VariableName[(subscripts)]

 

Returns

 

None

 

Parameters

 

Remarks

 

REDIM will preserve previous array data only if optional PRESERVE clause will be specified.

If PRESERVE is not present an empty array will be created and previous data will be deallocated.

 

Restrictions

 

See also

 

Dim

 

Examples

 

'---Arrays

Dim MaxItems As Long Value 10000

Dim MyArray(MaxItems) As String

 

'---Undimensioned array redimensioned later

Dim MyUndimensionedArray() As String

'...

ReDim MyUndimensionedArray(MaxItems)