Sub test2()
Sheets(2).Range("a1").CurrentRegion = ""
With Sheets(1)
.AutoFilterMode = False
With .Range("a1").CurrentRegion
.AutoFilter Field:=7, Criteria1:=">=0.4"
.SpecialCells(xlCellTypeVisible).Copy Sheets(2).[a1]
End With
.AutoFilterMode = False
End With
End Sub