Error with Array

[nightcrawler23]

What is wrong with this code

Dim arrCountries() As String
'ReDim arrCountries(4) As String
[COLOR="Red"]arrCountries = Array("US", "JP", "IN", "CN")[/COLOR]

The line in red gives me a type mismatch error

 

[VoG]

Try

Dim arrCountries()
arrCountries = Array("US", "JP", "IN", "CN")

 

[nightcrawler23]

Thanks VOG, that worked.

Can you also explain the reason. This has always bothered me.

 

[VoG]

I'm not sure of the underlying reason but to assign elements to an array like that the array has to be of type Variant.