Match Function best practice

[millhouse123]

I have a macro that loops through and compares two worksheets. I use the match function to check if a record in one exists in the other. Basically what I need to do is figure out a way to set up an if statement to execute one set of code if it exists and another if it does not.

What would be the best way to check for the existence of a record and execute code based on the result?

 

[VoG]

Try like this

If IsNumeric(Application.Match(Range("A1").Value, Sheets("Sheet2").Columns("A"), 0)) Then
'match found
Else
'no match
End If

 

[millhouse123]

Excellent - Many thanks for this advice.