Function Referencing An External Class When The Class Is Not Referenced

Sorry for the poor title. I'm trying to build a function that will copy dictionaries into another dictionary and then pass the new copied dictionary back to the original subroutine. There are some wasted duplication of arrays, dictionaries and collections; because I am teaching myself how to reference them. I also don't want to worry about properties in classes at the moment as they'll all be getting written to other dictionaries.

I haven't attempted to pass the copied dictionary back to the original subroutine yet. That'll be a problem for another day .

I'm having problems on Line 36 (coloured green); where I get a Run-Time error '451'; property let procedure not defined and property get procedure did not return an object.
I know the problem is that I'm trying to reference a field of a class in a dictionary and it's trying to check the class to get a reference what the actual field is and that's where it's encountering problems.
I imagine the solution is to put a reference to the class in there, however I'm trying to make this as versatile as possible in the future (and learn exactly how to reference dictionaries, collections, arrays etc...).

What would be the best way to do this guys? I've read every tutorial out there and I know it seems easy when you know how but you read a tutorial many times and think you have it all sussed, then you try it and fall at the first hurdle .

Please Login or Register  to view this content.

1.jpg
And in the class module Class1:

Please Login or Register  to view this content.

One needs to reference the Microsoft Scripting Runtime in order to run the application.

Sorry guys, the problem was I'm using a key I created myself which begins at 1. So the problem was in the function starting the loop at 0.

Replace with 1 and it's all good.

Please Login or Register  to view this content.