VBA Match Text in Different Worksheet

[kopite2002]

I'm trying to delete rows from other worksheets in a different workbook. I'm trying to use the MATCH function to find the row number that the unique ID exists on and then delete that row. But I can't get the MATCH command to work, despite trying all different syntax that I've found on this website.

Below is the command I'm running, which isn't working , any ideas?

MatchedRow = Application.WorksheetFunction.Match(MatchThis, RVSheet.Cells("A:A"), 0)

 

[doofusboy]

Have you tried:

MatchedRow = Application.WorksheetFunction.Match(MatchThis, RVSheet.Range("A:A"), 0)

 

[kopite2002]

That doesn't work either. I'm getting a runtime error 1004 "Unable to get the Match property of the WorksheetFunction class". Mean anything to anybody?