Statement with multiple And/Ors

[cfoye130]

I'm having trouble.... My loop has come to a cell where the first condition of the AND is true, and one of the second conditions of the OR is true (specifically the Sick Time condition). In this case I want the vba to move forward rather then exit the If, but it exits the If.

I suspect I have not written the AND/OR statement correctly as it treats only the 1st OR as the 2nd condition of the AND and not all the ORs together as the 2nd condition. Any assistance would be greatly appreciated.

 If Sheet3.Cells(I, 1) = Sheet5.Cells(C, 10) And _
                (Sheet3.Cells(I, 2) = "Vacation/Personal -  Employees Only" Or _
                Sheet3.Cells(I, 2) = "Paid Leave - Employees Only" Or _
                Sheet3.Cells(I, 2) = "Sick Time - Employees Only" Or _
                Sheet3.Cells(I, 2) = "Holiday - Employees Only") Then
                SickCheck = True
            End If

 

[VoG]

Try

If Sheet3.Cells(i, 1) = Sheet5.Cells(c, 10) And _
                (Sheet3.Cells(i, 2) = "Vacation/Personal -  Employees Only" Or _
                Sheet3.Cells(i, 2) = "Paid Leave - Employees Only" Or _
                Sheet3.Cells(i, 2) = "Sick Time - Employees Only" Or _
                Sheet3.Cells(i, 2) = "Holiday - Employees Only") Then
                SickCheck = True
            End If

 

[cfoye130]

Yeah, I edited my thread as soon as I posted it. That is how I had it. I was expermenting with out the parenthesis to see if it worked and that was the code that got pasted. So no dice, with or without the parentesis.

 

[cfoye130]

Wow, Im an idiot. Nevermind. Sorry!