Adding dictionary into dictionary and retrieving data

I'm not sure why you'd use a Dictionary as a key rather than an item, but:

Please Login or Register  to view this content.

As a separate note, writing this:

Please Login or Register  to view this content.

declares r1 as a Variant, not a Range. You have to specify the type for each variable.

And there's not much point to a Function that doesn't return anything.

Yes,

thank you rorya.

what be the syntax for retrieving key from dic2 ?

Please Login or Register  to view this content.

This is awesome, but i can not find key for dic2 for key(1) for dic.

I want to retrieve (after function in msgbox):
1) key from dic2 for dic - first key,

---->

declares r1 as a Variant, not a Range

Why my friend? I do not understand.

Best,
Jacek

Originally Posted by jaryszek

what be the syntax for retrieving key from dic2 ?

Please Login or Register  to view this content.

Use .keys not .items

Why my friend? I do not understand.

I just told you why - you have to specify the type for each variable. If you don't, you get the default type, which is Variant.

Originally Posted by jaryszek

Hi,

i am adding dictionary as keys and ranges as items into dictionary.

Please Login or Register  to view this content.

How to add keys and items into dic2 and dic3 in function above?

And how to retrieve them?
I want to take each of key later and use .exits method for dic2 and dic3 .

Please help,
Best,
Jacek

Maybe you using parent and child dict
Maybe like this but not sure what you want

Please Login or Register  to view this content.

Originally Posted by jaryszek

I set up variables.
Ranges where changed into Variant?

Where you declared them. This:

Please Login or Register  to view this content.

does not declare r1 as a Range and r2 as a Range. It is actually the same as:

Please Login or Register  to view this content.

To make them both Range objects, you must use:

Please Login or Register  to view this content.