Can't assign to an array

  • Article

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 that the array on the left side of the assignment is resizable and the types of the array match.

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

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.