Hi,

I have the following extract from a UDF:

If rRng.Value Like "*Pyrodur*" _
Or rRng.Value Like "*Pyrostop*" Then
    fTMS = "Fire"
    Exit Function
End If
Which Looks in a cell and if it contains these words (pyrodur or pyrostop) then class it as "Fire"

However I need to break this down a further level to:
If it contains (Pyrodur and CS) or (Pyrostop and CS) then its "Fire CS"
If it contains (Pyrodur and Stock) or (Pyrostop and Stock) then its "Fire Stock"

The field to look in would be displayed like this:
Pyrostop EI30-10 15mm CS -----------The result would need to be displayed as "Fire CS"
Pyrodur EW30-201 10mm CS -----------The result would need to be displayed as "Fire CS"
Pyrostop EI30-10 15mm Stock -----------The result would need to be displayed as "Fire Stock"
Pyrodur EW30-201 10mm Stock -----------The result would need to be displayed as "Fire Stock"

Importantly I can not get it to search just "CS" or "Stock" as there are other non fire products that fall into this.

Can an AND function be added to the code above e.g. Like *Pyrostop* AND *CS* but both must be present (not just pyrostop or CS)

Any suggestions?

Paul