Tag Archives: collection

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 , , , , | 55 Comments