macro/worksheet/chart interaction

[nc10001]

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

Problem - although the worksheet is updated at each time step, the
chart only updates when the macro has finished executing - and I want
to see the data being graphed as the simulation proceeds - is there
anyway of getting the macro to pause while the chart is updated - some
kind of handshake between EXCEL and the macro? (At the moment the only
way I can do this is to put a STOP in the code loop.)

Thanks in advance

nc10001

 

[Earl Kiosterud]

This post is in other newsgroups. Posting the same question in multiple
newsgroups can cause redundant effort on the part of the responders.