chart/worksheet/macro interaction

[nc10001]

I am running a macro which simulates an engineering application. Th
macro essentially time steps, sending the data at each time step to
worksheet, and a chart is set up to display the data in graphica
form.

Problem - although the worksheet is updated at each time step, th
chart only updates when the maacro has finished executing - and I wan
to see the data being graphed as the simulation proceeds - is ther
anyway of the macro asking EXCEL if it has finished updating a grap
before proceeding to the next calculation? (At the moment the only wa
I can do this is to put a STOP in the code loop.)

Thanks in advance

nc1000

 

[Earl Kiosterud]

nc,

Put a DoEvents statement in your code after you've updated the cells.