Type mismatch

[bknight]

In another thread I have been learning GetRows. Now my code produces a type mismatch on the following code step.

Code: Select all

ElseIf (recData(7, I) = "Entry" And recData(7, I + 1)) = "Exit" Then

In this example both are true why the mismatch?

[HansV]

Wrong placement of parenthesis.

Code: Select all

ElseIf (recData(7, I) = "Entry" And recData(7, I + 1) = "Exit") Then

or even

Code: Select all

ElseIf recData(7, I) = "Entry" And recData(7, I + 1) = "Exit" Then

[bknight]

Thanks I just wanted to make sure both of the conditions were included in the elseif