Excel VBA Search For Find Duplicate Values In Two Lists

[LalitPandey87]

you can also do it as below:

Worksheets("Sheet1").Range("H1").Resize(UBound(varFinalArr)).value = Application.Transpose(varFinalArr)