Share this Page URL
Help

Chapter 7. Working with Arrays > Declaring an Array Variable - Pg. 105

Working with 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 vari- ables 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 fixed values, called elements, that share the same data type and name. VBA inter- prets and processes the group of values as one variable. 7 IN THIS CHAPTER Introducing Array Variables . . . . . . . . . . . . .105 Declaring an Array Variable . . . . . . . . . . . . . .105 Understanding the Array's Index . . . . . . . . .106 Working with Array Elements . . . . . . . . . . . .107 Arrays with Multiple Dimensions . . . . . . . . .110 Expanding to Dynamic Arrays . . . . . . . . . . . .110