Sub Copier_sans_tri()
Dim t
t = Timer
With [A:A].SpecialCells(xlCellTypeConstants).EntireRow
.Copy Feuil2.[A1]
.Delete
End With
MsgBox Timer - t
End Sub
Sub Copier_avec_tri()
Dim t
t = Timer
With [A:A]
.SpecialCells(xlCellTypeConstants).EntireRow.Copy Feuil2.[A1]
.Resize(, 11).Sort .Cells(1), Header:=xlNo 'tri pour regrouper et accélérer
.SpecialCells(xlCellTypeConstants).EntireRow.Delete
End With
MsgBox Timer - t
End Sub