excel vba array redim preserve 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()"