vba - Run time error '1004' Unable to get the Match propertyof the WorksheetFunction class

Question

In my macro, I have the following code :

i = Application.WorksheetFunction.Match(str_accrual, Range(Selection, Selection.End(xlToRight)), 0)

where 'str_accrual' is a string captured earlier to this line and the Range selected is in a single row say from "A1" to "BH1" and the result will be a number which is the position of that string in that range selected.

When I run the macro, I get the error:

Run time error '1004' Unable to get the Match propertyof the WorksheetFunction class

But when I run the macro line by line using (F8) key, I don't get this error but when I run the macro continuously I get the error. Again, if the abort the macro and run it again the error doesn't appear.

Answer 1

I tried several times. It seems that if there is no match, the expression will prompt this error

if you want to catch the error, use Application.Match instead

Then you can wrap it with isError