VBA For loop taking way too long

[Baxta]

Hi guys, hoping you can help.

Im using a for loop to populate a spreadsheet from a HTTPrequest and its just taking ages. It already has to go through a JSON parser and populating the sheet cell by cell is just not practical.

Any help would be appreciated

Here we go:

Set json = lib.parse(HttpReq.ResponseText)
For x = 1 To json("results").Count
For y = 1 To lastColumn
Sheet11.Cells(x + 2, y) = json("results")(x)("" & Sheet11.Cells(2, y) & "")
Next y
Next x

 

[bfarley4]

I'm guessing you already turned off the screenupdates & alerts, but if not - I would definitely make sure u did.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
If above is already in place (which I'm guessing it is based code thus far) try using variables to store all the values (redim a(b)) - I've found this to speed things up for me for related data transfers / extracts across multiple network drives. It might require a little error logic though depending on data type.<o></o>
<o></o>
If you explain your project a little more and some of the sample date - I'll see if I can give better examples.<o></o>
<o></o>
Ben