InStr with Multiple Text in String

[reubanrao93]

Hi guys,

Currently im try to search a cell if it contain two specific text inside it using InStr function. However it is not working. Anything am I missing here?

If InStr(1, (Range("L1").Value), "Hello ") > 0 And InStr(1, (Range("L1").Value), "name ") Then

The tresult im loking for should be like this

Cell L1: "Hello there my name is" should be true
Cell L1: "Hello there my is " should be false

Cheers

 

[GWteB]

... a > 0 is missing:

If InStr(1, (Range("L1").Value), "Hello ") > 0 And InStr(1, (Range("L1").Value), "name ") > 0 Then

 

[Norie]

Try this.

If InStr(Range("L1").Value, "Hello ") > 0 And InStr(Range("L1").Value, "name ") > 0 Then

 

[Peter_SSs]

A slightly different approach would be

If LCase(Range("L1").Value) Like "*hello *" And LCase(Range("L1").Value) Like "*name *" Then