Option Explicit
Sub test()
Dim t() As Variant, i As Long
ReDim t(0 To Range("A65536").End(xlUp).Row, 0 To 2)
For i = LBound(t) To UBound(t)
t(i, 0) = Cells(i + 1, 1).Value
t(i, 1) = Cells(i + 1, 2).Value
t(i, 2) = Cells(i + 1, 8).Value
Next i
End Sub
Sub test2()
Dim t() As Variant, x As Long, i As Long
x = Range("A65536").End(xlUp).Row
t = Range("A1:B" & x).Value
ReDim Preserve t(1 To x, 1 To 3)
For i = 1 To x
t(i, 3) = Cells(i, 8).Value
Next i
End Sub