Find cell that does not contain string

[sharky12345]

I'm using this to find cells that contain part of a string;

If cell.Value = "*(V)*" Then

the relevant part being "(V)".....but now I want to reverse it by searching for cells that do not contain that, I've tried the following but it doesn't work;

If cell.Value <> "*(V)*" Then

Can anyone advise please?

 

[AlphaFrog]

Try this...

If Not cell.Value Like "*(V)*" Then

Your original code that finds the match should use the Like operator as well without the Not .

 

[MickG]

Try:-

If InStr(Cell.Value, "(V)") = 0 Then '"Do something"

 

[sharky12345]

Perfect - thanks guys!