worksheetfunction.match giving run time error '1004'

I'm trying to use the match function to try to cross reference some data, but I get:

Runtime Error '1004'
Unable to get the match property of the worksheet-function class

I know why I'm getting the error. I'm getting the error because the data I'm trying to match is not in the array.

How can I use this function to flag data that it cannot find or isn't part of the array being indexed?

note: the following code is in a for loop which loops through rows and colums (i and j) of the spreadsheet.

Please Login or Register  to view this content.

You can store the match part in a Variant if you use Application.Match instead:

Please Login or Register  to view this content.