UniqueArray.vbs
ArrV = Application.Transpose(Range([a1], Cells(Rows.Count, "A").End(xlUp))) 'Stores all the value in the column 'A' of Sheet 'COUNTRY' to the Array 'ArrV'!
For I = LBound(ArrV) To UBound(ArrV) 'Uses 'Scripting Dictionary' object to store only unique value!
ScrDIC(ArrV(I)) = 1
Next
ArrV = ScrDIC.Keys 'Dumps the Unique values from 'Scripting Dictionary' object into the Array.