Arrays in Excel VBA

The main purpose of is to help you work with VBA arrays.

Arrays help you, Excel, and VBA work more efficiently with data. When you work with VBA, you are likely to often deal with arrays.

:

• Is part of my Book Series; and
  
• Assumes you know about the topics covered in: (i) My previous Book Series, particularly the Book Series; and (ii) The previous Books in the Book Series, particularly .
  

Your knowledge about variables continues to be useful as you learn about arrays. There are important differences between:

• Regular (or scalar) variables; and
• Arrays.

is divided into six Chapters.

• Chapter 1 is an introduction to arrays.
• In Chapter 2, you learn how to declare arrays.
• In Chapter 3 and Chapter 4, you learn how to work with the following (more advanced) arrays: (i) Multidimensional arrays; and (ii) Dynamic arrays.
• In Chapter 5, you learn how to carry out several basic array operations: (i) Filling an array with data; (ii) Getting information from an array; and (iii) Erasing array data.
• Chapter 6 contains several practical examples to help you practice working with arrays in VBA.