Sub SpprimerDecaler()
Dim Data , Zaza As Range, Lig, Col
Dim LastR, LastC As Long
LastC = Cells.Find("*", [A1], SearchDirection:=xlPrevious).Column
LastR = [A65000].End(xlUp).Row
Set Data = Range("A5:Q" & LastR)
Application.ScreenUpdating = False
With Data
For Lig = 1 To .Rows.Count
For Col = .Columns.Count To 1 Step -1
If .Cells(Lig, Col) = "" Then .Cells(Lig, Col).Delete shift:=xlToLeft
Next Col
Next Lig
End With
Application.ScreenUpdating = True
For Each zaza In Data
If zaza.MergeCells Then
zaza.MergeCells = False
End If
Next
End Sub