Excel 2007 VBA Programming with XML and ASP

Part IIIPart III

Keeping Track of

Multiple Values

Although you can use individual variables to store data while your

VBA code is executing, many advanced VBA procedures will require

that you implement more efficient methods of keeping track of multi-

ple values.

In this part of the book, you’ll learn about working with groups of

variables (arrays) and storing data in collections.

Chapter 8 Working with Arrays

Chapter 9 Working with Collections and Class Modules

199