Sub sup_doublons()
Dim i As Integer, k As Integer, var As Integer
For i = 1 To Range('A65536').End(xlUp).Row
var = 0
nom1 = Range('A' & i).Value
For k = i + 1 To Range('A65536').End(xlUp).Row
nom2 = Range('A' & k).Value
If nom2 = nom1 Then
var = 1
Rows(k).Delete
k = k - 1
End If
Next k
If var = 1 Then Rows(k).Delete
Next i
End Sub