Adding to a collection (item and key) through named ranges

[RawlinsCross]

Hi there,

I have two columns of data that I want to add as an item/key to a collection. I have the two columns individually named but I can change that if necessary (i.e. two columns under one name). What's the best way to get these data into a collection?

 

[Fluff]

You would need to loop through the rows & add them to the collection individually.
https://excelmacromastery.com/excel-vba-collections/