Sub Test()
Dim C As Range
Dim DerliC As Long
Dim Tablo As Variant
' Dernière cellule de la colonne C (3)
DerliC = Columns(3).Find("*", , , , , xlPrevious).Row
' Tableau des éléments à rechercher
Tablo = Array("TABLEAU DE SERVICE", "M: Matin, A: AprŠ", "R: RCYC, L: LTP,")
' Boucle
For Each C In Range("C2:C" & DerliC)
' Condition si valeur de cellule dans le tableau des exceptions
If Not IsError(Application.Match(C.Value, Tablo, 0)) _
Or IsEmpty(C) Then Range("c" & C.Row & ":L" & C.Row).ClearContents
Next
End Sub