ce code n'on( plus ne fonctionne pas:
Sub DELETE_Espace()
Dim lastrow, mycolumn
Dim fini As String
lastrow = ActiveSheet.UsedRange.Rows.Count
mycolumn = ActiveCell.Column
For x = 2 To lastrow
'Cells(x, mycolumn) = RTrim(Cells(x, mycolumn))
'fini = RTrim(Cells(x, mycolumn))
'Cells(x, mycolumn) = fini
Cells(x, mycolumn) = Trim(Cells(x, mycolumn))
Cells(x, mycolumn) = LTrim(Cells(x, mycolumn))
Cells(x, mycolumn) = RTrim(Cells(x, mycolumn))
Next x
End Sub