I want to fill an array with found values using worksheetfunction.match and cannot find a way to make it work. I have tried multiple ways and only get 'Unable to get the Match property of the WorsheetFunction class'.
This is the loop I am using to match the values. It should not have any complications.
For i = 1 To UBound(MyConcat)
If IsNumeric(WorksheetFunction.Match(Range("AG" & (20 + i)), Range("AN21:AN" & LastRow), 0)) = True Then
ResultArray(arraycounter) = MyConcat(i, 1)
arraycounter = arraycounter + 1
Else
End If
Next
Thanks for your help.
Bookmarks