Hi Everybody!

I'm new here and new with VBA as well. I'm trying to create a Dictionary of Dictionaries with the following code:

Dim dic As Dictionary, e, s
Set dic = New Dictionary '<- main dictionary
Set dic(a) = New Dictionary

where dic(a) stands for 100 baby dictionaries that I'm trying to fill by looping the variable a from 1 to 100. It turns out to be not feasible. Do I have to Set all dic(1), dic(2), dic(3)...dic(100) individually which works? Since using a variable for those baby ones would be extremely easy for downstream analysis, I'd really appreciate it if someone could help on this.

Thanks in advance.