Sub test_II()
'(auteur: jindon)
Application.ScreenUpdating = False
[B] Dim X As String[/B]
Dim r As Range
'For Each r In Range("a1", Range("a" & Rows.Count).End(xlUp))
X = InputBox("Quelle colonne?")
[B] For Each r In Range(X & 1, Range(X & Rows.Count).End(xlUp))[/B]
r.Value = CleanAll(r.Value)
r.WrapText = False
Next
Application.ScreenUpdating = True
End Sub