Arrays / Array Variables

Hi Daniel

Arrays are useful when you must store a number of values of the same type, but you do not know how many, or you do not want to create individual variables to store them all.

The indexing in an array by default begins at 0 so declaring an array as

Dim SalesYear(5) as Integer

will allow you to store 6 years (0 t0 5) as the 5 sets the upper limit of the array, not the number of memory spaces

Then in the code SalesYear(3) will return the value stored in that section of the array. This is refered to as a Static array

But the best way to write Arrays is to create Dynamic arrays.

In this case you define the array but not the size. This can be defined later as seen below:

Dim SalesYear as Integer

ReDim SalesYear (1 To 20)

This sets an Array with space for 20 integers

NB You can change the size of a dynamic array, but not the data type

Hope this helps

Carlos