Omit first row of array

[tiredofit]

If my data has two columns in columns A and B but I just want column A, I can write this:

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

What can I do if I want to populate MyArray not from cell A1 but from cell A2?

I don't want to have to loop.

Thanks

 

[RoryA]

Offset by 1 then resize by the number of rows -1.

 

[tiredofit]

Thanks