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.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.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()"Copyright © 2021 Codeinu
Forgot your account's password or having trouble logging into your Account? Don't worry, we'll help you to get back your account. Enter your email address and we'll send you a recovery link to reset your password. If you are experiencing problems resetting your password contact us
