J'ai essayé ceci mais ça ne fonctionne pas !
Sub trier_horizontal()
Dim DerCol As Integer, Derlig As Integer, i As Integer, j As Integer
Application.ScreenUpdating = False
Derlig = Range("A65536").End(xlUp).Row
For i = Derlig To 3 Step -1
If Cells(1, i) = Cells(1, i - 1) Then
For j = 7 To DerCol
If Cells(j, i) > 0 Then
Cells(j, i - 1) = Cells(j, i)
End If
Next j
Rows Line(i).Delete
End If
Next
End Sub
Merci à vous.