Comparing text to cells but only partial match

[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