VBA Initialise/Initialize String/Number Array (not variant)
Initializing String Array in VBA
To initialize a string array in VBA, you can use the following code:
Dim myArray(2) As String
myArray(0) = "First"
myArray(1) = "Second"
myArray(2) = "Third"
This code initializes a string array named myArray
with three elements and assigns values to each element.
Initializing Number Array in VBA
To initialize a number array in VBA, you can use the following code:
Dim myNumArray(2) As Integer
myNumArray(0) = 1
myNumArray(1) = 2
myNumArray(2) = 3
This code initializes a number array named myNumArray
with three elements and assigns values to each element