Public Array Compile Error - Can't assign to array [duplicate]

Question

When I want to populate a public array, it throws this error:

Option Explicit

Public myArray(5) As Variant

Sub addToArray()
    myArray() = Array(1, 1, 0, 0, 1, 1)
End Sub

It gives me a "Compile error: Can't assign to array" error:

Anyone an idea what might went wrong? This is just a short array. I might make it way bigger. Defining each value separately is not what I want.

Pᴇʜ · Accepted Answer · 2021-07-21 14:39:05Z

1

You need to declare as variant without size (for the array)

Public myArray() As Variant

to be able to use it like

myArray = Array(1, 1, 0, 0, 1, 1)

answered Jul 21, 2021 at 14:39

Pᴇʜ

57.9k10 gold badges55 silver badges75 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1