Hi All
So I have a few arrays made up of country codes, each array represents a region.
I'm hoping to somehow use a select case statement to correctly select the correct region (array) for any given country code.
So what I'd like to do is have a country code and then using select case look inside each array and if it finds a match then thats the region?
I don't know if this is possible but something like this made up code (which doesnt work):
Code
Origin = .Cells(i, OriCol).Value
ASPA = Array("CN", "AU", "HK")
EMEA = Array("DE", "SE", "GB")
Select Case Origin
Case ASPA
Region = "Asia"
Case EMEA
Region = "Europe"
Case Is = "US"
Region = "US"
Case Else
End Select
Display More
So if Origin was "AU" then it would return Region = "Asia", if it was "DE" then it would return Region = "Europe" etc.