Sub test()
Sheets("Ballenberg").Range("A5:H65536").ClearContents
ligne = 5
For n = 2 To Sheets("Feuil1").Range("A65536").End(xlUp).Row
If InStr([COLOR=blue]UCase([/COLOR]Sheets("Feuil1").Range("C" & n[COLOR=blue][COLOR=black])[/COLOR]), "BALLENBERG[/COLOR][COLOR=blue]"[/COLOR]) <> 0 Or InStr([COLOR=blue]UCase([/COLOR]Sheets("Feuil1").Range("E" & n[COLOR=blue][COLOR=black])[/COLOR]), "BALLENBERG[/COLOR][COLOR=blue]"[/COLOR]) <> 0 Or InStr([COLOR=blue]UCase([/COLOR]Sheets("Feuil1").Range("F" & n[COLOR=blue][COLOR=black])[/COLOR]), "BALLENBERG[/COLOR][COLOR=blue]"[/COLOR]) <> 0 Then
Sheets("Feuil1").Range("A" & n & ":H" & n).Copy Destination:=Sheets("Ballenberg").Range("A" & ligne)
ligne = ligne + 1
End If
Next n
End Sub