Can't assign to an array

Each element of an array must have its value assigned individually. This error has the following causes and solutions:

• You inadvertently tried to assign a single value to an array variable without specifying the element to which the value should be assigned.

  To assign a single value to an array element, you must specify the element in a subscript. For example, if MyArray is an integer array, the expression MyArray = 5 is invalid, but the following expression is valid:

  MyArray(UBound(MyArray)) = 5
  

• You tried to assign a whole array to another array. For example, if Arr1 is an array and Arr2 is another array, the following two assignments are both invalid:

  Arr1 = Arr2    ' Invalid assignment.
  Arr1() = Arr2()    ' Invalid assignment.
  

  To assign one array to another, make sure the array on the left-hand side of the assignment is resizable and the types of the array match.

  Note You can place a whole array in a Variant, resulting in a single variant variable containing the whole array:

  Dim MyArr As Variant
  MyVar = Arr2()
  

  You then reference the elements of the array in the variant with the same subscript notation as for a normal array, for example:

  MyVar(3) = MyVar(1) + MyVar(5)
  

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