Hide multiple rows with different values

[PBark78]

Hello

I have a column B with rows 6 - 42 showing days of the week and I am trying to hide Tuesdays, Thursdays, Fridays. I have been able to hide just one of those days but I cannot make it hide rows for all values

What I have is this

Sub HideRows()
StartRow = 6
EndRow = 46
ColNum = 2
For i = StartRow To EndRow
If Cells(i, ColNum).Value = "FRIDAY" Then
Cells(i, ColNum).EntireRow.Hidden = True
Else
Cells(i, ColNum).EntireRow.Hidden = False
End If
Next i
End Sub

What can I do to get excel to hide all of the rows based the requirements

 

[Sequoyah]

Hi PBark78,

If Cells(i, ColNum).Value = "FRIDAY" Or Cells(i, ColNum).Value = "TUESDAY" Or Cells(i, ColNum).Value = "THURSDAY" Then