How to force excel to continue macro if cell updated without using Application.Wait or loop

[love_guy_1977]

Dear Sir,

I need your great help to write a macro for the following:

I'm using [For each oCell in Range("A1:A200")] which representing Stock Code.

In each cell from B2 till CM2 there is a function linked to Stock Market Program (meaning to make stock prices as live in excel)

when run [For each oCell in Range("A1:A200")], I copy the base line which is in [B2:CM2] then use find function Stock Code and replace it with oCell Code.

I do it without waiting, then the excel will hang up (Stop working bez so many function to be updated. Therefore, I need a VBA to check each cell in Range(oCell.offset(0,1), oCell.offset(0,90)) if updated or not (not meain #N/A)
If updated, go to next oCell and so on

I use Application.Wait and loop but it doesn't work where these two function doesn't allow excel to update Stock Market Function

Thank you very much if help me

 

[VoG]

Maybe

Do Until Application.CalculationState = xlDone
    DoEvents
Loop

 

[love_guy_1977]

Thank you very much