Whats Next

In this chapter you learned that by creating an array, you can write procedures that require a large number of variables. You worked with examples of procedures that demonstrated how to declare and use a one-dimensional array (list) and a two-dimensional array (table). You also learned the difference between a static and dynamic array. This chapter ended by introducing you to five built-in VBA functions that are frequently used with arrays, as well as the ParamArray keyword. You now know all the control structures that can make your code more intelligent: conditional statements, loops, and arrays.

Later in this book you will learn how to use collections instead of arrays to manipulate large amounts of data. By using the knowledge acquired in Chapters 1 through 7, you can now begin writing VBA procedures that can automate tasks that seemed impossible to automate before you began reading this book. The next chapter explains how to programmatically manage files and folders.

This page intentionally left blank

0 0

Post a comment