Looping through a Scripting.Dictionary using index/item number

by

According to the documentation of the Item property:

Sets or returns an item for a specified key in a Dictionary object.

In your case, you don’t have an item whose key is 1 so doing:

s = d.Item(i)

actually creates a new key / value pair in your dictionary, and the value is empty because you have not used the optional newItem argument.

The Dictionary also has the Items method which allows looping over the indices:

a = d.Items
For i = 0 To d.Count - 1
    s = a(i)
Next i

More Related Contents:

  1. Does VBA have Dictionary Structure?
  2. Set Auto Filtering multiple wildcards
  3. Can Advanced Filter criteria be in the VBA rather than a range?
  4. delete Autofilter Field resullt using the header Name
  5. Get list of sub-directories in VBA
  6. So, I have 6 “master” files to then divide into 40 separate files
  7. Application.Match gives type mismatch
  8. What does the Call keyword do in VB6?
  9. Count and Highlight keywords within phrases
  10. How to securely store Connection String details in VBA
  11. How to type Unicode currency character in Visual Basic Editor
  12. Detect merged cells in VBA Excel with MergeArea
  13. Hash Table/Associative Array in VBA
  14. Using VBA code, how to export Excel worksheets as image in Excel 2003?
  15. Parse HTML content in VBA
  16. How to add a DocumentProperty to CustomDocumentProperties in Excel?
  17. Is “Value” actually the default property of the Range object?
  18. VBA – how to conditionally skip a for loop iteration
  19. How to use VBA SaveAs without closing calling workbook?
  20. Removing the password from a VBA project
  21. Removing special characters VBA Excel
  22. Excel VBA Formula German/French/Italian/Russian/Dutch/Foreign Function
  23. selenium vba code to zoom out webpage to 60%
  24. Return a range from A1 to the true last used cell
  25. When is a MailItem not a MailItem? [closed]
  26. Timing Delays in VBA
  27. What are the benefits and risks of using the StrPtr function in VBA?
  28. How do I avoid run-time error when a worksheet is protected in MS-Excel?
  29. Where does Outlook store the VBA code files?
  30. Working with current open email

Leave a Comment