Populate array with large filtered range

with WSTemp.Cells(1).currentregion
    myarray = application.index(.value, evaluate("row(1:" & .rows.count & ")"),array(2,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26))
end with