View Single Post
  #25   Report Post  
Posted to microsoft.public.excel.programming
Alan Beban Alan Beban is offline
external usenet poster
 
Posts: 200
Default Sub to extract uniques from 200k data in xl03


"Alan Beban" wrote:

Then, in the VBEditor, select Tools|References and check Microsoft
Scripting Runtime; I believe this step is also necessary in John
Walkenbach's code cited by Tom Ogilvy, though neither John nor Tom
mentioned it.


Tom Ogilvy wrote:
It wasn't mentioned because it isn't necessary.

It isn't necessary to check scripting runtime because it uses the

builtin
collection rather than starting up another DLL.

==
Regards,
Tom Ogilvy


Thanks. I didn't notice the use of the built-in collection in the
Developer Tip. It raises an interesting question whether the use of a
Dictionary, which could avoid the looping to fill the list box, might be
faster because of the NoDupes.Items property of the Dictionary.

Alan Beban