+ Reply to Thread
Results 1 to 2 of 2

Help to adjust code for nested dictionary to array

  1. #1
    Registered User
    Join Date
    05-05-2016
    Location
    Holland
    MS-Off Ver
    2016
    Posts
    23

    Help to adjust code for nested dictionary to array

    Hi Guys!

    Could you help me to adjust my code (to speed it up) for printing a nested dictionary to the worksheet?
    Creation of the nested dictionary (from https://stackoverflow.com/questions/...ted-dictionary)
    Please Login or Register  to view this content.
    and the code to print the dictionary to the worksheet (from https://stackoverflow.com/questions/...heet-using-vba)
    Please Login or Register  to view this content.
    However, the second code writes the dictionary immediately to the sheet, which is very slow.
    Therefore I'd like the function "printtoWS" to return a result array.
    But the function is written in such a way that it calls itself, so it does not store the result array.

    Thanks in advance!
    Last edited by max138; 12-21-2017 at 05:39 AM.

  2. #2
    Registered User
    Join Date
    05-05-2016
    Location
    Holland
    MS-Off Ver
    2016
    Posts
    23

    Re: Help to adjust code for nested dictionary to array

    If there is too little information, please let me know.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. # want to know VBA different as colekction,as array and as dictionary#
    By daboho in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 12-24-2016, 12:08 PM
  2. [SOLVED] Comparing Arrays: What are tradeoffs b/w using a Dictionary vs a nested For-Each loops?
    By joe31623 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-04-2016, 01:29 PM
  3. Cant get data to populate in VBA code from array & scripting dictionary
    By leanne2011 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-25-2015, 04:38 AM
  4. help assigning elements of dictionary to array and then pasting array into worksheet
    By welchs101 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 12-05-2013, 10:37 AM
  5. [SOLVED] Putting a dynamic array in a dictionary
    By wizuriel in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-16-2013, 04:10 PM
  6. 2 Dimentional Array as Dictionary Item
    By erock24 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 05-05-2011, 11:13 AM
  7. Nested dictionary items, how do you access them?
    By treyr in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-15-2010, 12:23 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1