Arrays in VBA

Many scientists make extensive use of arrays in their calculations. Because arrays in VBA can be quite confusing, this chapter provides detailed coverage of this important topic. 

Equating a variable in VBA to a worksheet range automatically creates an array in VBA in which each array element contains the value stored in the cell. Using the Set command to equate an object variable in VBA to a worksheet range automatically creates an array of "cell" objects in VBA. If you change the value of one of the array elements by means of your VBA code, the value in that cell in the worksheet will change, as illustrated by the Sub procedure in Figure 15-3. 

In the example shown in Figure 15-5, a 2-D range on a worksheet becomes an array in VBA. Then the array elements are written back to the worksheet with a single line of code. 

ArrayDemos.xls contains 14 Sub or Function procedures that illustrate various features of using arrays in VBA. 

Using arrays in VBA is now covered in depth in a separate chapter. 

Numerical Methods for Chemical Engineers Using Excel , VBA, and MATLAB 2.13.2 Dynamic Arrays in VBA... 

---