Sub Test()
Dim Cel As Range
For Each Cel In Range("P3:P" & Range("P" & Rows.Count).End(xlUp).Row)
If Cel = "CA" Then Cel.Offset(, -1).Resize(, 2).ClearContents
Next Cel
End Sub
Sub Test()
Dim Cel As Range
For Each Cel In Range("P3:P" & Range("P" & Rows.Count).End(xlUp).Row)
If Not IsError(Cel) Then
If Cel = "CA" Then Cel.Offset(, -1).Resize(, 2).ClearContents
If Cel = "COM" Then Cel.Offset(, -1).Resize(, 2).ClearContents
If Cel = "COMP" Then Cel.Offset(, -1).Resize(, 2).ClearContents
If Cel = "repos" Then Cel.Offset(, -1).Resize(, 2).ClearContents
Else
Cel.Offset(, -1).Resize(, 2).ClearContents
End If
Next Cel
End Sub