Extract List of terms and combine on a Table

d4okeefe · #9 06-28-2018, 03:07 PM

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.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Need macro to make list of "defined terms"	glnz	Word VBA	8	09-07-2022 02:09 PM
How to extract names from a list	flyoverrunner	Excel	3	06-06-2018 04:54 AM
Best Practice for Indexing Multiple Word Terms and Sub-Terms	jhy001	Word	4	11-06-2017 02:08 PM
How to Combine a Table of Contents Page with Another Document	Dante49	Word	2	10-24-2016 01:53 PM
Need to extract two word domains from a list (BULK)	Maxwell314	Excel	3	12-08-2014 06:17 PM