Answers for "vba redim preserve or create new array"

VBA

1

redim array vba

Redim MyArray(10) ' Resize to 10 elements.

For i = 1 To 10 ' Loop 10 times. 
 MyArray(i) = i ' Initialize array. 
Next i 
'You can resize just the left-most dimension of the array
Redim Preserve MyArray(15) ' Resize to 15 elements.

Posted by: Guest on December-14-2020

Source

Code answers related to "vba redim preserve or create new array"

Code answers related to "VBA"

Browse Popular Code Answers by Language

Python

Javascript

Whatever

Shell/Bash

CSS

Html

PHP

SQL

Java

C#