Fresh Excel Tips

Quick and Easy Excel Tips and Tutorials

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 [...]