Not sure if I'm in the right Category for this question, but here goes.

A simple routine to populate an array from a worksheet.

Option Explicit
Dim myarray As Variant

Sub read_as_entire_()
'myarray = Worksheets("Sheet2").Range(Cells(1, 1), Cells(6, 1)).Value

myarray = Worksheets("Sheet2").Range("a1:a6").Value

'Sheet2.Range("b1:b6") = myarray

Sheet2.Range(Cells(1, 2), Cells(6, 2)) = myarray

End Sub


If I use the commented out lines I get a 1004 Runtime error.
If I run it as is, it works. I need the Cells method to reference other ranges.