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++.

Yeah, I know that! The topic here, though, is VBA vs VB.NET and so not
much point dragging other langs into it!<IMO

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion