I am brand new to VBA (taught myself) and this is probably a very simple and stupid question but I have an array in VBA and I can't for the life of me get it into the ranges I specify. Instead it just populates the cells I have specified with the first value of the array. The even more perplexing part is that when I manually place them in the cells (aka range("A1") = MyArray(1), range("A2") = MyArray(2)) it works perfectly. Obviously that isn't what I want to do though.

I currently am trying to populate the range using this:

Range("A1:A20") = MyArray

I have also tried:

Range("A1:A20").Value = MyArray

I have already transposed MyArray and it is dimmensioned as Dim MyArray(1 to 20) as variant.

Please give me something, I am sure this is so simple, but I am completely at a loss.