Need to add additional criteria to macro to hide row based on text in cell

[jmpatrick]

I have a macro that works nicely to hide rows based on the content of a single column. Works great, but I can't figure out how to add additional criteria.

Here's the relevant part of the macro:

StartRow = 5
EndRow = 1000
ColNum = 3
For i = StartRow To EndRow
If Cells(i, ColNum).Value <> "" Then
Cells(i, ColNum).EntireRow.Hidden = False
Else
Cells(i, ColNum).EntireRow.Hidden = True
End If
Next i

This hides all rows from 5 to 1000 if there is nothing in column 3. I'd like to specify additional criteria which would also hide the row, "Saturday" "Sunday" "New Years Day", etc.

 

[jmpatrick]

I figured it out!

If Cells(i, ColNum).Value = "" Or Cells(i, ColNum).Value = "Saturday" Or Cells(i, ColNum).Value = "Sunday" Then