Not Like has no effect while looping an Array

Question

I am looping the array using the code below, however, the final condition, And Not...like, has no impact at all.

For i = 2 To UBound(arr)
    If arr(i, 2) Like "*Helideck*" Or _
       arr(i, 5) Like "*-HD-*" And _
       Not arr(i, 16) Like "*Fire*" Then arrH(i, 1) = "True"

Answer 1

you can add parentheses instead... mixing an Or with the And can be tricky, but using the parentheses properly can accomplish what you want as well. Here's a rough example: https://stackoverflow.com/questions/45704996/if-condition-with-and-combine-multiple-or-in-vba-excel