How to Use and Define Arrays with correct Syntax in Excel VBA
For this article, we will be looking at how to use and define arrays in Excel VBA. You declare arrays just as you do variables, except you specify the size of the array in the declaration as shown in the example below.
Dim y(1 To 4) As Double
Dim x(4) As Double
Dim M(1 To 8, 1 [...]