Thanks, macropod and sorry I didn't know about the code tags, but will add in future.
Could I ask 2 quick questions re the code:
(a) Do I put as many terms as will fit into:
Code:
vFindText = "England,France"
And then continue in:
Code:
vFindText = vFindText & ",New Zealand,Zambia"
And then if that runs out, copy and paste the above to create a 3rd vFindText line (my current list runs to well over 500 terms so I imagine I need quite a few lines)?
(b) I need spaces in some terms so only whole words are found, eg 'An ' - do I just put a space before the following comma?