Iterate over VBA Dictionaries ?



  • 2 Answer(s)

    The best solution for Iterate over VBA Dictionaries :

    For Each varKey In oDic.Keys()
        Range("A" & varKey).Value = oDic(varKey)
    Next
    

    Make sure that, iterator must be declared as a Variant.

    Answered on January 7, 2019.
    Add Comment

    For Each varKey In oDic.Keys()
    Range
    (“A” & varKey).Value = oDic(varKey)
    Next

    Answered on March 5, 2019.
    Add Comment


  • Your Answer

    By posting your answer, you agree to the privacy policy and terms of service.