Hi SV,


'-------------
Thanks for replying, can you also spell what the function means, sorry
amstilla novice wiht VB...
'-------------

See the Instr function in VBA help.

However, the function returns the position of a substring
(your search string 'US') within another string - in your case,
the cell value.

The first parameter specifies the start position of the search;
the second argument specifies the string to be searched; the
third specifies the search string ad the last argument defines
the search method; in this instance the search is case insensitive.

The If construct employed results in an implicit boolean
conversion of the function result: a result of zero (not found) is
returned as False; any other value is returned as True.


---
Regards,
Norman