View Single Post
 
Old 06-28-2018, 03:07 PM
d4okeefe d4okeefe is offline Windows 10 Office 2016
Advanced Beginner
 
Join Date: Apr 2013
Posts: 77
d4okeefe is on a distinguished road
Default

Error 9 means that the arr1 or arr2 variable has a problem. Make sure that these lines:
Code:
Dim arr1(1 To 1000)
Dim arr2(1 To 1000)
... appear in your code. Or, possibly, there are more than 1000 countries in your search. If so, you could increase the size of the array to 10000.

Better, yet paste your code, and let's take a look. If you can, click the # sign above, so that your code is formatted.

Here's Microsoft's VBA tutorial.
Reply With Quote