macro save 1 plot every 2...

[pagheca]

Hi,
I created a macro to plot a row of data from a worksheet in a chart. The macro scroll between rows of data one by one, and then save the chart as a new jpg. This is the relevant code:

Please Login or Register  to view this content.

The problem is that the macro save 1 chart every 2, not all of them as I need. I do not understand why as I sum only 1 in the do while loop. Any idea?

thanks and cheers!
pagheca

[Andy Pope]

what causes the saved filename to change?

[pagheca]

thanks for the speedy answer.
the filename is changed by the line:

Please Login or Register  to view this content.

cheers,

[Andy Pope]

no, the file name is read in by that line.

What changes the contents of the cell B3?

[pagheca]

the string was the name of the originating data file, but into each data file there were 2 lines of data! So, I was writing 2 charts into the same file...

Excellent error-spotting! Thanks very much, Andy!!!
cheers,