Sub Bouton1_QuandClic()
Dim plage As Range
Dim c As Range
Set plage = Range('a1').CurrentRegion
For Each c In plage
If Len(c) > 0 Then
If WorksheetFunction.CountIf(plage, c) > 1 Then
'plage = Replace(plage, c, '')'MARCHE PAS
End If
End If
Next c
Sheets('feuil2').Range('a1').Resize(plage.Rows.Count, plage.Columns.Count) = plage.Value
End Sub