redim preserve vba code example
Example: vba redim
' Used at the procedure level to reallocate storage space for dynamic array variables.
' Example
Dim arr() as Long
ReDim ar() 'creates new array "ar" - "ReDim ar()" acts like "Dim ar()"
' Used at the procedure level to reallocate storage space for dynamic array variables.
' Example
Dim arr() as Long
ReDim ar() 'creates new array "ar" - "ReDim ar()" acts like "Dim ar()"