Waiting for Calculations

[coodeebuu]

I have a spreadsheet that is pulling in data from bloomberg. I need to have my VBA code wait until the data has populated the cells. What code do I need to add to wait for the data until proceeding with further steps in the VBA code?

 

[pboltonchina]

Add this into your code and adjust for the required length of time

Application.Wait Now + TimeSerial(0, 0, 5) 'this is a 5 second delay

 

[Ruddles]

If you know which the last cell to be populated is, you can loop round waiting for something to appear in it. Something like this:-

do while isempty(range("x99")) : doevents : loop

Is that something you could work with?