ARRAYS

Arrays are one of the first data structures learned by beginning programmers. Not only common as a teaching tool, arrays are frequently used by professional programmers to store like data types as one variable. In short, arrays can be thought of as a single variable that contains many elements. Moreover, VBA arrays share many common characteristics:

• Elements in an array share the same variable name.

• Elements in an array share the same data type.

• Elements in an array are accessed with an index number.

As noted, elements in an array share the same variable name and data type. Individual members in an array are called elements and are accessed via an index. Just like any other variable, arrays occupy memory space. To explain further, an array is a grouping of contiguous memory segments, as demonstrated in Figure 7.5.