Hi, I receive dozens of address lists from customers. The customers
use a templated excel workbook that has a set array of address fields.
One of these fields is "Country".

Sometimes there are errors in the country names and I need them to be
ISO compliant. Ideally, I'd like to set up a workbook that contains a
list of country codes and a macro workbook that

1. works on the already open address list workbook
2. Checks that the address list workbook has the value in Range("A10")
= "Country"
3. Check all entires in column 10 are within the ISO list, If not, it
highlights those that are not compliant.

As an added extra, it would check for certain commom "errors" and
correct them (e.g. change UK to UNITED KINGDOM).

I've been tying myself in knots trying to use the
worksheetfuntion.countif() function to count if each cell in column 10
is contained in the ISO list. I can't get it to work. Any help is
greatly appreciated!