Hello all,
How can I improve the performance of the code below. I got two array DestArray and strArray. I would like to check if all numbers in DestArray exist in strArray and get the position in the strArray if it exist.
/ P
For i = 1 To UBound(DestArray) Pos = Application.Match(DestArray(i, 1), strArray, False) If Not IsError(Pos) Then Else MsgBox "Not Found" End If DoEvents Next i
Bookmarks