Re : Excel VBA and WorkSheetFunction (Match)
 

Re : Excel VBA and WorkSheetFunction (Match)

1. With reference to the following code statement,

List3 = Application.Match(List1, List2, 0)

List1, 2 and 3 are declared Variants.

2. List1 and 2 are extended arrays of long text strings (variable
lengths say, 50 to 300 characters) read from 2 separate columns of a
worksheet.

3. The given code statement has caused an exception.

4. However, when List1 and 2 are shortened, the code execution is
satisfactory.

5. There is apparently a limitation on the functionality of
Application.Match.

6. Please comment and share your experience.

7. Regards.