kweaver
Well-known Member
- Joined
- May 12, 2009
- Messages
- 2,934
- Office Version
- 365
- 2010
I'm using this:
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.
Code:
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.
Last edited: