combining operators
In my macro I use the following line and it is working (vac is string
variable)
If Cells(i, "A").Value = vac And Cells(i, "b") = "EQ" Then
My macro needs another "OR" condition also, for that i am using
If Cells(i, "A").Value = vac And Cells(i, "b") = "EQ" or
"BE" Then
but it results in type mismatch error. How to combine "and" and "or"
conditions?
|