Sub miseajour()
Application.ScreenUpdating = False
Dim DernCol As Long
DernCol = Cells(1, Columns.Count).End(xlToLeft).Column
Dim CelSelec As Integer
CelSelec = Selection.Cells.Count
Dim colonne_en_cours As Long
With Sheets("Feuil1")
For N = 1 To CelSelec
For colonne_en_cours = 1 To DernCol
If ActiveCell = .Cells(ActiveCell.Row + N, ActiveCell.Column) Then
.Cells(ActiveCell.Row + N, ActiveCell.Column).Cut (.Cells(ActiveCell.Row + N, ActiveCell.Column + N))
End If
Next
Next N
End With
Application.ScreenUpdating = True
End Sub