GS wrote:
Well this has nothing to do with VB.NET vs VBA! It just proves that
.NET's Array.BinarySearch function (a Framework feature usable by all
dotnet languages) works better than Excel's Match function. Try using
your VB.NET code on an automated instance of Excel where you substitute
its Array.BinarySearch function with Excel's Match function and see what
I mean.

Besides, that's certainly not how I would do it. I can iterate 2 500000
element arrays seaching for duplicates, put those found into a 3rd
array, then dump the result back into a worksheet in less than 8 seconds
using pure VB[A]. Try doing the same with pure VB.NET and let me know
how you make out!


You can do that even faster in C++.