Range has no values

There are limitations on the way you can specify the number of elements in an array. This error has the following cause and solution:

• You specified your array boundaries incorrectly. For example, the following ranges are invalid:

  Dim MyArray(10 To -5) ' Descending order not permitted. Dim MyArray(0 To 0) ' No elements in the array.

  Check to be sure your syntax is correct. For example, the following range is valid:

  Dim MyArray(-5 To 10)

For additional information, select the item in question and press F1 (in Windows) or HELP (on the Macintosh).