For Loop not working; step-by-step does work

Hello all,

I use the code below to loop through a column of values and an external formula (meaning not provided from excel, an addon I downloaded) to download data for each of those values, and then compile the data in another sheet.

Please Login or Register  to view this content.

When I run the code, no data is downloaded to be copy/pasted into the sheet. However, when I go through the code step-by-step (press f8), then it seems to work fine. Changing the amount of time or use of application.calculate doesn't seem to help. I've also tried changing the forumula auto-calculate feature off and on and screen updating. it seems like whatever I have in the for loop it doesn't iterate through, and does everything at once.