This Array Has Fewer Dimensions than You Have Provided Error

You tried to execute a built-in array method that requires a one-dimensional array on a multi-dimensional array.


Example

You can't sort a two-dimensional array.

Dim aInts(3,3) as Integer
Dim i,j as Integer
For i=0 to 2
 For j=0 to 2
  aInts(i,j)=i*j
 Next
Next
aInts. Sort //doesn't work on 2D arrays

Using syntax that indicates that you are referencing an element in a two-dimensional array when it has been declared as a one-dimensional array:

Dim aInts(3) as Integer
aInts(0,0)=3 //incorrect

Trying to change a one-dimensional array to a two-dimensional array with a Redim statement:

Dim aInts(3) as Integer

Redim aInts(5,5)

See Also

Append, Insert, Redim, Remove, Sort methods; Dim statement.