Write Dictionary items to Worksheet

[WmBarth]

I want to copy an array from one workbook (wbML) to another (wbDB) using the dictionary method.
I want three columns of data from wbML: Ref, Name, Surname. It has many more columns of data and I can't always be certain where the data I want will be located.

I'm not certain that I'm adding the range correctly to the dictionary item.
Second, I would like to write the data to wbDB.

Any help would be appreciated.

Please Login or Register  to view this content.

[jindon]

One way
1)

Please Login or Register  to view this content.

Key is "i"

2)

Please Login or Register  to view this content.

[WmBarth]

Thank you, again!