Cannot get MATCH function in VBA to work

[kweaver]

I'm using this:

Application.WorksheetFunction.Match(Str, Sheets("Master").Range("C12:C300"), 0)

in my routine.
Str is a text string (a person's name in the format "lastname, first name" -- such as Str = "Brown, John") and getting "unable to get match property..." error.
What's wrong with my statement?

The error happens when a person is not found. I wanted to capture the error to test to see if the person is found or not.

 

[mart37]

This error occurs when no match is found. Is Str a correct string?

 

[kweaver]

Yes, Str is a valid string (person's name) but I wanted to know (capture) the fact that it is NOT found in the list of names if that's the case.

 

[mart37]

Application.WorksheetFunction.Match gives an error when there is no match.
Application.Match does that not.

MatchRow= Application.Match(Str, Sheets("Master").Range("C12:C300"), 0)
If IsError(MatchRow) Then
     MsgBox "No match found"
Else
    MsgBox "Match found in row " & MatchRow
End If

 

[kweaver]

Thank you! Playing around, I just discovered that as you answered. Much appreciated.