Why can't I reference another dictionary from inside a foreach loop? VBA

Question

    Debug.Print distdic(1813)
For Each Key In storedic.Keys
     NewBook.Sheets("Store Bulletin List").Cells(x, 1).Value = Key
     NewBook.Sheets("Store Bulletin List").Cells(x, 2).Value = distdic(Key)
     Debug.Print distdic(Key)
    x = x + 1
Next

The first debug produces a result but that second debug does not even if the Key is 1813

Why can't I use my distdic from inside the foreach loop?

is distdic defined in the code before the loop? And isn't the syntax something like distdic.Items(key)? — Scott Holtzman
– Scott Holtzman, Commented Jan 21, 2016 at 19:02
yes, and it's a fully loaded dictionary. Values are in there for sure. — Johnson Jason
– Johnson Jason, Commented Jan 21, 2016 at 19:03
fixed.. provided answer here for posterity. Thank you for your help. — Johnson Jason
– Johnson Jason, Commented Jan 21, 2016 at 20:19

Johnson Jason · Accepted Answer · 2016-01-21 20:19:01Z

1

        Debug.Print distdic(1813)
For Each Key In storedic.Keys
     NewBook.Sheets("Store Bulletin List").Cells(x, 1).Value = Key
     NewBook.Sheets("Store Bulletin List").Cells(x, 2).Value = distdic(Cint(Key))
     Debug.Print distdic(Cint(Key))
    x = x + 1
Next

Problem was the datatype of the Key. The above fixed it.

answered Jan 21, 2016 at 20:19

Johnson Jason

7213 gold badges13 silver badges32 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Why can't I reference another dictionary from inside a foreach loop? VBA

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related