Business Solutions VBA and Macros for Microsoft® Office Excel® 2007

Chapter 19. Arrays

IN THIS CHAPTER

Declare an Array	441
Fill an Array	443
Empty an Array	444
Arrays Can Make It Easier to Manipulate Data, But Is That All?	445
Dynamic Arrays	447
Passing an Array	448
Next Steps	448

An array is a type of variable that can be used to hold more than one piece of data. For example, if you have to work with the name and address of a client, your first thought might be to assign one variable for the name and another for the address of the client. Instead, consider using an array, which can hold both pieces of information—and not for just one client, but for hundreds.

Declare an Array

Declare an array by adding parentheses after the array name. The parentheses contain the number of elements in the array:

Dim myArray (2)

This creates an ...