View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Rowan Drummond[_3_] Rowan Drummond[_3_] is offline
external usenet poster
 
Posts: 414
Default Refreshing Charts inside a Macro

You may need to show us the code but a couple of guesses in the
meantime. Make sure application.screenupdating = true and try inserting
the DoEvents statement after you update the chart.

Hope this helps
Rowan

Chad wrote:
I have a macro that simulates time for an equation. I then have the results
of this equation feeding a chart which provides a simple animation of what is
occuring. However the chart does not upate until the macro has finished it's
steps. Anyhelp???