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
|