A Proper IF Statement?

[Ark68]

Is this valid "IF" statement?

If .Range("H" & rnum1) = "RIM Park Outdoor Facilities" And .Range("BB" & rnum1) <> "N*" Then

I'm not sure ifyou can use 'ADD"' and if you can, if you can use a wildcard "*" in the criteria.

It's not showing the results anticipated.

 

[Norie]

It is valid but it probably won't work properly as you can't use wildcards.

If you want to check that the first character of column BB is not equal to "N" you can use Left.

If .Range("H" & rnum1) = "RIM Park Outdoor Facilities" And Left(.Range("BB" & rnum1),1) <> "N" Then

 

[Ark68]

Thanks Norie ... I should have known better.