vba courses london - How do you do an array?

Hi Toby

To create an array in VBA, you need a statement such as:

Dim myArray(1 To 8) As Integer

This will create an array of Integers using the values provided in this case 1 to 8.

an alternate is
Dim myArray As Variant
myArray = Array(1, 2, 3, 84 5)

There are many other types of array, i.e. an array of strings that you should look into.

Hope this helps

David