empty the Cell content if multiple match is found |VBA|EXCEL|

[jackbhai]

I have a Excel Where I want to empty the Cell content if multiple match is found like "SUP","AL" with in the Range


Image Link :

https://paste.pics/517160d93175e1e52a7ef6576524a322

My Code But not Working :

Dim c As Range
For Each c In Range("A7:AE7")
If c.Value = "SUP" OR "AL" Then
.Range.Clear
End If
Next c

 

[Fluff]

How about

Dim c As Range
For Each c In Range("A7:AE7")
   If c.Value = "SUP" Or c.Value = "AL" Then
      c.Clear
   End If
Next c

 

[jackbhai]

Fluff i have tried this one But it Delete only one single Row i want to delete => How many rows are been used that many only ?
For example => forget about first two headers Days name and Date 01 .. 02 ... and so on
the remaining rows after first two headers => is 6 Rows only that many rows should check => where ever their is SUP and AL between Column Range A:AE and Row Range of 1:6 used Rows should be Check the match condition and Delete the Data in Cell and Set cell property to No fill (Means nothing is fill Not even with Color)

i have tried your code But it works with only one single Row