Salut starwaso,
Pour effacer le contenu des lignes:
Sub ViderLignes()
Dim i As Long
Application.ScreenUpdating = False
For i = Cells(Rows.Count, 2).End(xlUp).Row To 1 Step -1 ' 2 pour la colonne "B"
If Cells(i, 15) = "oui" Then Range("B" & i & ":O" & i).ClearContents
Next i
Application.ScreenUpdating = True
End Sub
pour supprimer les lignes entièrement:
Sub SupprimerLignes()
Dim i As Long
Application.ScreenUpdating = False
For i = Cells(Rows.Count, 2).End(xlUp).Row To 1 Step -1 ' 2 pour la colonne "B"
If Cells(i, 15) = "oui" Then Rows(i).Delete
Next i
Application.ScreenUpdating = True
End Sub
@++