Spell Check Place Names

[pjacob]

Dear VBA Friends,

Greetings.

Once again I need help in solving a logic.

I have 7 place names as below:

Abu Dhabi
Dubai
Sharjah
Ajman
Umm Al Quwain
Ras Al Khaimah
Fujairah

They are in their correct spellings and in Proper Case and are places in the United Arab Emirates.

Now, I need a VBA code that checks the spellings and case on a given column and corrects the incorrect spelling by referring to the correct ones.
Sounds kind of simple. But the errors could be all sorts of mix and match.

Kindly advise how do I go about it.
I am guessing it would be a blend between regular expressions and dictionary map.
But I am going to let the experts here have a say...

Thanks & Best Regards,
Philip