Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi,
I've setup a nested Dictionary object using classes that initialise nested dictionary objects. This appears to build ok, however when I try and iterate over this nested object I get the following debug message: "Run-time error '424', Object required" My code snippet is as follows; For i = 1 to MDict.Count For j = 1 to MDict.Items(i).subDict1.Count For k = 1 to MDict.Items(i).subDict1.Items(j).subDict2.Count ... Next k Next j Next i The run-time error occurs on the For j = 1... line. I'm not sure the syntax is correct as this is my first attempt at using Dictionaries. I also tried the following with the same result. For Each md In MDict.items For Each sd1 In MDict.Item("subDict1").Items For ach sd2 In MDict.Item("subDict1").Item("subDict2").Items ... Next Next Next Any help is greatly appreciated. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
iterating through a Dictionary object | Excel Programming | |||
ByRef argument type mismatch when passing dictionary object | Excel Programming | |||
Using the Dictionary object | Excel Programming | |||
Dictionary Object in Windows XP | Excel Programming | |||
iterating through all properties of an object | Excel Programming |