Single column array

[confusion123]

Assume in the cells A1 to D4 are the numbers 1 to 16, A1 = 1, B1 = 2, etc.

How can I define an array consisting of 1 column and 3 rows, specifically so that it is populated by column C?

If I wrote:

Dim MyArray() As Variant

MyArray = Cells(1, 1).CurrentRegion.Value

that would declare an array with 4 rows and 4 columns.

something like MyArray = Cells(1, 3).Resize(3, 1), though MyArray = Range("C1:C3") does work.

Thanks

EDIT: Got it:

MyArray = Cells(1, 3).Resize(3, 1).Value

 

[Tubal]

Thanks for posting your answer!