VBA For "Not Like"

[moonbase]

Hi,

Could anone please help me with the VBA code for a "Not Like" comparison ?

I get an error when I try to use the "Not Like" comparison

 If Range("A" & i).Value Not Like "CLOS*" Then

If I use <> "CLOSED" And <> "CLOSE" And <> "CLOSING" then it all runs OK, however I would prefer to get something similar to a "Not Like" operator to work with a wildcard such as *

Thx & Rgds
moonos

 

[VoG]

Try

If Not Range("A" & i).Value Like "CLOS*" Then

 

[Norie]

Try this.

If Not (Range("A" & I).Value Like "CLOS*") Then

 

[VoG]

Try this.

If Not (Range("A" & I).Value Like "CLOS*") Then

Why the brackets?

 

[Norie]

Peter

They probably aren't needed in this case - I think using that kind of syntax dates back for me to when I studied Logic at university.

I also think it's a good idea to use parentheses to make sure that what your testing is what you want to test.

Then you've also got to consider operator precedence in calculations.

Again I don't know if that would make any difference here but you never know.

I mean Man Utd beat Man City in injury time and Celtic beat Hearts too.

 

[moonbase]

Thank you for the replies, code now OK.

Peter

I mean Man Utd beat Man City in injury time.

The Man Utd win was achieved with referee precedence over a chronological constant. Quite what it has to do with "Not Like" is a bit unclear unless you are a Man City supporter and then it is definitely "Not Liked"


Rgds
moonos