Sub NettoieFeuil1()
Application.ScreenUpdating = False
Application.EnableEvents = False
Sheets("Feuil2").Select
ActiveSheet.Unprotect Password:=""
Sheets("Feuil1").Select
ActiveSheet.Unprotect Password:=""
Dim derlg As Long, i As Long, deb As Long
With Sheets("Feuil1") 'à remplacer par nom de ta feuille
derlg = .Range("r" & .Rows.Count).End(xlUp).Row 'remplacer A par colonne concernée
For i = derlg To 1 Step -1
If .Range("r" & i) = "bleu" Then Exit For
Next i
'***** partie modifiée
deb = i + 1
'** copier
.Range("E" & deb & ":E" & derlg & ",G" & deb & ":H" & derlg & ",J" & deb & ":J" & derlg & ",S" & deb & ":T" & derlg).Copy
End With
'** coller
With Sheets("Feuil2")
.Range("I" & .Range("I" & .Rows.Count).End(xlUp).Row + 1).PasteSpecial Paste:=xlPasteValues
.Protect Password:="", DrawingObjects:=True, Contents:=True, Scenarios:=True
.EnableSelection = xlNoRestrictions
End With
'****** Fin modif
With Sheets("Feuil1")
.Protect Password:="", DrawingObjects:=True, Contents:=True, Scenarios:=True
.EnableSelection = xlNoRestrictions
End With
Application.ScreenUpdating = True
Application.EnableEvents = True
End Sub