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