A beginner's introduction to programming with Visual Basic for Applications. This video tutorial is number 22 in a series designed to get you programming from scratch. An array variable is a group of contiguous memory locations. An array is particularly useful when manipulating large amounts of data, with a relatively small amount a code. Array variables are most often used in conjunction with iteration (looping) constructs such as For Next and Do Loop. Here you will find out how to refer to elements of an array by their index numbers.