bonjour,
Sub RecopieUneLigneSurDeux()
Application.ScreenUpdating = False
Range("B1").Select
For Each Cellule In Range("A1", Range("A" & Rows.Count).End(xlUp))
Selection = Cellule
Selection.Offset(1, 0) = Cellule
ActiveCell.Offset(2, 0).Select
Next
End Sub
Cordialement