You could try

Application.ScreenUpdating = False
Sheets("Sheet1").Range("C2:C11").Copy _
Sheets("Sheet2").Range("B2:B11")
Application.ScreenUpdating = True

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Elceller in distress" wrote
in message ...
Thanks, we are 1/2 of the way home.

Now that I see the chart, it flickers every time it updates. Is it
possible
to make it update smoother? I would like to get it to transition smoothly
similar to a picture in PowerPoint. The program starts by zeroing out the
values in the chart, it then fills in the values one second at a time.
Looking at the chart below, it fills in the y value of time 1, waits 1
second
and fills in the value of time 2...


X
X
X
X
X
XXXXXXXXXXXXXXXXXXXXX
1 2 3 4 5 6 7 8 9 10
Time



"merjet" wrote:

Don't use the select keyword. Just copy and paste such as follows.

Sheets("Sheet1").Range("C2:C11").Copy _
Sheets("Sheet2").Range("B2:B11")

Hth,
Merjet