T
tkt_tang
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.
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.