Vba array example

You can declare an array to work with a set of values of the same data type. An array is a single variable with many compartments to store values, while a typical variable has only one storage compartment in which it can store only one value.

Dynamic array vba

Refer to the array as a whole when you want to refer to all the values it holds, or you can refer to its individual elements.

For example, to store daily expenses for each day of the year, you can declare one array variable with 365 elements, rather than declaring 365 variables.

Each element in an array contains one value. The following statement declares the array variable with 365 elements. By default, an array is indexed beginning with zero, so the upper bound of the array is 364 rather than 365.

To set the value of an individual element, you specify the element's index.

The following example assigns an initial value of 20 to each element in the array.

Changing the lower bound

Use the Option Base statement at the top of a module to change the default index of the first element from 0 to 1.

In the following example, the

how to create an array of strings in vba

how to create dynamic array in vba