Excel VBA Macro With Time Pause for Add-in

[mbabla]

Hi,

1> I have an Excel Macro that involves copying a bunch of formulas into many cells based on an Add-in. (i.e., Copy $A$2 to $A$3:$A$100, then $A$2 to $A$101:$A$200, etc.). I have to run these sequentially as otherwise the application runs out of memory (RAM is not the issue here).
2> The add-in pulls data from the internet.
3> The problem I have is that the VBA Macro runs without finishing the calculation/ download resulting from the add-in, from the first paste range to the next, next, etc. - so I end up with just NA/VALUE/not downloaded messages.
4> I added pause functionality with Application.Wait, but that does not work well either.
5> Does anyone have a suggestion what may work better here?
Thanks in advance for your consideration and help.

Best,

Bob

 

[Stiuart_W]

Can you not test the content of the cells before running the code? So check if N/A/VALUE present then don't run code - put a while loop in which will exit when all data is downloaded.