Find specified text in string

[TheOneWeDreamOf]

I'm comparing two strings.
Car tire type hypersonic 3 extra = wsFrom.Cells(j, KolomFrom)
Car tire ultra advanced hypersonic 3 type extra = wsTo.Cells(i, KolomTo)

Is it possible to find multiple predefined values in a string.

So If wsFrom.Cells(j, KolomFrom) contains "tire" & "extra" And wsTo.Cells(i, KolomTo) also contain "tire" & "extra" Then... etc.

This is how it doesn't work :

Please Login or Register  to view this content.

Hope it's clear enough.

Thanks!

[KOKOSEK]

Try something like this:

Please Login or Register  to view this content.

[TheOneWeDreamOf]

Works great! Thanks!

Is there a way to get rid of the case sensitivity?

[KOKOSEK]

Use LCase or UCase.

Please Login or Register  to view this content.

[TheOneWeDreamOf]

Thanks Kokosek! Perfect!

[KOKOSEK]

You welcome.
If You happy with solution, please use thread tools and mark thread as SOLVED.

Thanks for rep.