Need to decipher/understand this function

[vpan]

Hi all,

The one thing in VBA i havent quite learned yet is arrays/dictionaries.

Unfortunately trying to debug a macro that is built entirely through dictionary mappings and arrays. Was wondering if someone could help me understand what is happening in the following function?

Please Login or Register  to view this content.

[6StringJazzer]

It looks like array1 and array2 are horizontal ranges (i.e., contiguous cells in the same row). In a Dictionary, each entry has a unique key, which can be any data type, and a value. In the loop it is using the values in array1 as the keys and corresponding values in array2 as the values.

The tricky part here is that because the keys are unique, if array1 has any duplicate values, only the rightmost value in array2 corresponding to the duplicates in array1 is going to stick in the dictionary. I would guess that is the whole reason for using the dictionary here in the first place, to remove duplicates.

(This code assumes that array2 is at least as long as array1. If that is not true there will be a run-time error.)