Tag Archives: scripting

Dictionary VBA Class update

I’ve uploaded a new version of the Dictionary Class¬†and a helper KeyValuePair Class. This exposes the KeyValuePairs collection so iteration is now very fast, about 2 seconds to iterate 1 million items using a for each loop: ¬† dim oKeyValuePair … Continue reading

Posted in Excel/VBA | Tagged , , , , | 40 Comments