Not Like????

[melewie]

Hi all,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o></o>
I am trying to create and loop that will identify if a cell does not contain "MX". I have created several before to find if a cell does contain certain characters<o></o>

[/FONT][/COLOR]
[COLOR=black][FONT=Verdana]Cells(RowNo, 2).Value Like "*" & "MX" & "*" Then<o:p></o:p>[/FONT][/COLOR]

<o></o>
<o></o>
But I can’t seem to get does not contain to work.<o></o>
<o></o>
Any help would be great.<o></o>
<o></o>
Thanks<o></o>

 

[Andrew Poulsom]

Like this?

If Instr(1, Cells(RowNo, 2).Value, "MX") = 0 Then

 

[Richard Schollar]

Hi

You can use Like eg:

 If Not cell.Value Like "*MW*" Then

But it would be better in my opinion to use Instr:

If Instr(1,cell.Value,"MW")=0 Then  'cell doesn't contain MW

 

[melewie]

Thank you both.

works perfectly

 

[RoryA]

Assuming you are using Like in an If..Then construct, you could just add your proessing code to the Else part.