Problem in understanding vba code

[dylanpong]

Hello everyone,

I am new to excel <acronym title="visual basic for applications">vba</acronym> and try to work on some lookup problems. I have searched for some previous post and find one of it is useful in my problems. Here's the link:VBA Macro multiple value lookup

I can successfully generate the result but have difficulty in understanding the coding. Theres a term

.Add Dn.Value, Array(n, 2)

within the coding. I have done some research and believe that this statement is to adding content into the dictionary. However, i am not quite sure why the terms Array(n,2) is used in this coding
Also in the other line, theres a term

Q = .Item(Dn.Value)

, but in the next line it uses Q(1) and Q(0) instead, i cannot understand what the line is doing.

 

[RoryA]

The item being added is an array. That's why you can use Q(0) and Q(1) later to access the elements.