Sub EssAi()
Dim i As Long, DerLig As Long
DerLig = Range("E" & Rows.Count).End(xlUp).Row
For i = DerLig To 2 Step -1
If Not IsNumeric(Cells(i, 5)) Then Rows(i).EntireRow.Delete
Next i
End Sub
...j'espère être plus clair (c pas évident)...
Sub EssAi()
Dim i As Long, DerLig As Long
DerLig = Range("E" & Rows.Count).End(xlUp).Row
For i = DerLig To 6 Step -1
If Not IsNumeric(Cells(i, 5)) Or Cells(i, 5) = "" Then Rows(i).EntireRow.Delete
Next i
End Sub
derligne=Cells(Application.Rows.count,"E").End(xlup).Row