identifying range containing a word

[Godders199]

Hello, just after some help with one element of my coding, all the rest works. I have effectively built a hierarchy of conditions for rows on a excel spreadsheet that i want to populate a summary tab. all works fine apart from this element, which does not error, it simply does not pick up that i dont want any row that in the column Qproductcodes contains the word "Non"
The word might appear in cell mulitiple times .


Sheets("checkSmart").Range(QProductCodes &R).Value = "=*Non*" Then

i have also tried *Non* and **Non** but can not get it to work.

does anyone know what i have to put around he word "Non" for the code to pick it up.

thanks

I am also having to populate a sheet with all the rows containing "non" so am stuck until i can get this to work.

 

[wideboydixon]

If Sheets("checkSmart").Range(QProductCodes &R).Value Like "*Non*" Then

WBD

 

[Godders199]

thanks alot, works perfectly