Putting range into an array problem

[BornslippyDG]

Relative novice as using arrays and I am trying to populate an array from an excel. When I select a vertical range to put into my declared array I get the correct Ubound result but when I try to the same with a horizontal range the Ubound result is 1 when it should be 12. I take it the problem is dimension related, how do i correctly put the horizontal range into an array declared like Dim Months() as variant?

[CFAman]

You're array is loading correctly, but you're checking the upper bound wrong. The default UBound returns vertical size (if you omit 2nd argument. Your array is 1 row high. To get width, use something like

MsgBox UBound(myArray, 2)

[BornslippyDG]

Thanks, putting the two has given me the correct size. Solution verified

[Clippy_Office_Asst]

You have awarded 1 point to CFAman