Comparing text to cells but only partial match

[Regouin]

i have the following

If RangeAI.Value = cell.Value Or RangeAI.Value = "0000" Then
        NotEqual = False
End If

How do i chance the second bit so that it doesnt just hit on the entire string but also when it is only a partial hit? I know how to do that with find, but not with the value thing.

probably a stupid question, but i really cant find the answer.

TIA Frank

[Bob Phillips]

If RangeAI.Value = cell.Value Or RangeAI.Value = "0000" Then
NotEqual = False
End If

How do i chance the second bit so that it doesnt just hit on the entire string but also when it is only a partial hit? I know how to do that with find, but not with the value thing.

If RangeAI.Value = cell.Value Or RangeAI.Value Like "*0000*" Then 
    NotEqual = False 
End If

[Regouin]

thanks, i was so close

tried

RangeAI.Value Like "0000"

and tried

RangeAI.Value = "*0000*"

but didnt think of comparing them, it works beautifully thanks.

Frank