Business solutions Automating Microsoft

7. Working with Arrays

IN THIS CHAPTER

Introducing Array Variables

Declaring an Array Variable

Understanding the Array’s Index

Working with Array Elements

Arrays with Multiple Dimensions

Expanding to Dynamic Arrays

Introducing Array Variables

So far, the variables you’ve encountered have been straightforward in that all variables have a purpose, a data type, and eventually, a value. Sometimes variables aren’t quite so simple. Sometimes a variable can equal more than one value at the same time. In this chapter, you learn how array variables store more than one value.

In general terms, an array refers to a large group of similar items. In mathematical terms, an array is rectangular set of values in rows and columns. A VBA array is a set of ...