When declaring arrays, we can define the lower and uppper bounds of the array indices. For example, the following code declares an array of 1000 doubles and initializes the value of each item in the array to = 1.5.

One of the benefits of using arrays is that they can be easily traversed using the For i =. Then the elements of the array can be referenced like this: x(1) = Cells(4,1) One-Dimensional ArraysĪ more efficient way to handle the problem described above is to declare a one-dimensional array variable as follows: Dim x(1 To 10) As Double This works, but it is not an efficient approach, especially for cases where you have hundreds or thousands of items in the vector. Then in your code, would reference the variables independently: x1 = Cells(4,1) One solution would be to declare your variables like this: Dim x1 As Double Suppose you have a vector called 'x' with ten double values.

For example, one may have a list (vector) or matrix of numbers that need to be stored and used as part of some type of linear algebra calculations. In many applications (especially in engineering), it is necessary to work with variable containing a set of related data.

Visual basic for excel array