In VBA I have created a scripting dictionary called finDict that contains ~72k keys and items. I'm trying to write the list of keys to a worksheet.
The code below correctly prints all of the keys in finDict, but it is extremely slow:
For Z = 1 To finDict.Count
ActiveWorkbook.Sheets("Test").Range("A" & Z) = finDict.Keys(Z - 1)
Next Z
I tried replacing that code with the code below, but for some reason this code replaces most of the printed keys with "#N/A":
ActiveWorkbook.Sheets("Test").Cells(1, 1).Resize(finDict.Count) = Application.Transpose(finDict.Keys)
Can anyone spot what the issue is??
The code below correctly prints all of the keys in finDict, but it is extremely slow:
For Z = 1 To finDict.Count
ActiveWorkbook.Sheets("Test").Range("A" & Z) = finDict.Keys(Z - 1)
Next Z
I tried replacing that code with the code below, but for some reason this code replaces most of the printed keys with "#N/A":
ActiveWorkbook.Sheets("Test").Cells(1, 1).Resize(finDict.Count) = Application.Transpose(finDict.Keys)
Can anyone spot what the issue is??