J-walk's excel 2000 vba book comes with an animation file that uses
interations to produce a fluccuating sine wave. Why is it that if I
copy the exact same sheet to a new workbook and copy the associated
macro to that new workbook, the animation does not work properly. If
you have not seen this (or the book) and need more details, let me
know.

I am trying to understand this better and it thoroughly confused me. I
can have both workbooks open (j-walks and the new book) with access to
his macro and the one I duplicated from his. Using the new workbook I
cannot get either macro to animate the graph. Using his workbook, I
can get both macros to animate it.

I have tried turning on iterations, but that did not make a difference.
When I run the macros it recalculates all of the chart source data, but
the chart does not change.

What am i doing wrong??


--
TEAM
------------------------------------------------------------------------
TEAM's Profile: http://www.excelforum.com/member.php...o&userid=22810
View this thread: http://www.excelforum.com/showthread...hreadid=393457

I have narrowed the problem down, I think. I created a new chart right
next to the chart that animates. I made both charts the same type, but
still only the original chart is dynamic with the data. The newly
created chart references the same data and changes if the data is
changed manually, BUT it does not change when the macro changes data
rapidly. I must be missing a chart setting or refresh rate. Any
ideas?? Both of these charts are in the same sheet. One works to
animate and the other does not.


--
TEAM
------------------------------------------------------------------------
TEAM's Profile: http://www.excelforum.com/member.php...o&userid=22810
View this thread: http://www.excelforum.com/showthread...hreadid=393457