non-case sensitive 'string' search?

Try this instead of like

If InStr(1, Cells(ptr, astColumn), "Filming", vbTextCompare) > 0 Then

Originally Posted by mike7952

Try this instead of like

If InStr(1, Cells(ptr, astColumn), "Filming", vbTextCompare) > 0 Then

That works, cheers Mike!!

Can you explain how it works?

i know the syntax for the INSTR function is:
InStr( [start], string, substring, [compare] )

is it the case that vbTextCompare 'is-not' case sensitive?

how does the > 0 part work?