Hi,
I would like to do the following:
From an array populated by country codes i would like to lookup the country name in a named range on the form: CountryCode CountryName, i.e. the second column. Then for each country code in the first array, the found name should be stored in another array. Why wont this work f.x.:
For i = 1 to whatever
CountryNames(i) = Application.Match(CountryCode(i), CountryCodeArrayRange, 0).Offset(0, 1).Value
Next i
I might be making som "obvious" mistake, so please tell me if so!
Bookmarks