Sub Macro1()
Dim Derlig&, c As Range
Derlig = Worksheets("Feuil1").Range("A" & Rows.Count).End(xlUp).Row
For Each c In Worksheets("Feuil1").Range("A5:M" & Derlig).Cells
If c = "" Then
'on a trouvé au moins 1 cellule vide
Worksheets("Feuil1").Range("A5:M" & Derlig).SpecialCells(xlCellTypeBlanks).Delete Shift:=xlUp
Exit For
End If
Next
End Sub