Sub Copie()
Dim Ligne As Long, Feuille As String, Plage As Range
With Sheets("ArchivMouv")
Feuille = .[U2]
Ligne = .Cells(.Rows.Count, 14).End(xlUp).Row
Set Plage = Intersect(.Range("4:" & Ligne), Union(.Range("N:Q"), .Range("S:S"), .Range("U:V")))
End With
With Sheets(Feuille)
.Range("4:4").Resize(Ligne - 3).Insert
Plage.Copy
.Range("C4").PasteSpecial xlValues
End With
End Sub
Daniel