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).