Sub suppression_ligne()
Dim nbligne As Long
nbligne = Range("B1").CurrentRegion.Rows.Count
For i = nbligne To 1 Step -1
If Cells(i, 20).Value = "STEP File" Then
Cells(i, 20).EntireRow.Delete
ElseIf Cells(20, i).Value = "SOLIDWORKS Drawing Document" Then
Cells(i, 20).EntireRow.Delete
ElseIf Cells(20, i).Value = "PDF" Then
Cells(i, 20).EntireRow.Delete
End If
Next i