Declare and Initialize String Array in VBA

Question

This should work according to another stack overflow post but its not:

Dim arrWsNames As String() = {"Value1", "Value2"}

Can anyone let me know what is wrong?

Answer 1

Try this:

Dim myarray As Variant
myarray = Array("Cat", "Dog", "Rabbit")