[COLOR=blue]Sub[/COLOR] Supr_lignes()
Application.ScreenUpdating = [COLOR=blue]False[/COLOR]
Liste = "EUR,GBP,USD,ISIN,"
[COLOR=blue]With[/COLOR] Sheets("Feuil1")
[COLOR=blue]For[/COLOR] i = .Cells(Rows.Count, 1).End(xlUp).Row [COLOR=blue]To[/COLOR] 1 [COLOR=blue]Step[/COLOR] -1
[COLOR=blue]If[/COLOR] .Cells(i, 1) = "" [COLOR=blue]Or[/COLOR] InStr(Liste, .Cells(i, 1) & ",") <> 0 [COLOR=blue]Or[/COLOR] _
IsNumeric(Left(.Cells(i, 1), 1)) [COLOR=blue]Or[/COLOR] _
IsNumeric(Left(.Cells(i, 1), 2)) [COLOR=blue]Then[/COLOR] .Rows(i).Delete
[COLOR=blue]Next[/COLOR]
[COLOR=blue]End With[/COLOR]
Application.ScreenUpdating = [COLOR=blue]False[/COLOR]
[COLOR=blue]End Sub[/COLOR]