I can read cell values into variant arrays without a problem but have not succeeded in the opposite direction, that is, copying array values (integers or whatever) to worksheet cells.
My rudimentary question is why the below routine returns zeros instead of the numbers 2, 4, 6. I have tried declaring the array as Variant without improvement. Quick help appreciated.
Dim i As Integer
Dim MyArr(3) As Integer
For i = 1 To 3
MyArr(i) = i * 2
Range("B1:B3").Value = MyArr ' returns zeros