N
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
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