Assign Match result to a variable

Hi all,

I am trying to assign the result of a match function to a variable, as I will need to use it several times and don't want to run the function repeatedly.

I thought the below code would do this, but I receive the Run-time error '438' : Object doesn't support this property or method.

code:

For i = 2 To LastRow
rownum = Application.WorksheetFunction.Match(Worksheets(Sheet_Name) & "'!J" & i, "All Codes'!B:B", 0)
Next i

Any suggestions will be appreciated! Thanks