Sub Test() arr = Sheet1.Range("A1:H27") arr2 = Array(1, 2, 5, 7) For i = 0 To 3 Sheet2.Cells(1, i + 1).Resize(UBound(arr, 1), 1) = WorksheetFunction.Index(arr, 0, arr2(i)) Next i End Sub
Sub Test() arr = Sheet1.Range("A1:H27") arr2 = Array(1, 2, 5, 7) For i = 0 To 3 Sheet2.Cells(1, i + 1).Resize(UBound(arr, 1), 1) = WorksheetFunction.Index(arr, 0, arr2(i)) Next i End Sub