Sub AAAAAA()
Dim arr, i&, j%, Brr, n&
arr = Sheet1.UsedRange
Sheet2.Activate
ReDim Brr(1 To UBound(arr), 1 To 10)
For i = 3 To UBound(arr)
If arr(i, 159) > 5 Then
For j = 1 To 10
Brr(i - 2, j) = arr(i, j + 0)
Next
End If
Next
[A3].Resize(UBound(Brr), 10) = Brr
End Sub