macro to automatically export gif/png of carts

Hi everyone,

I'm good at excel, but inexperienced at VBA and macros. I use Excel 2003.

I have a macro (kind supplied by the forum moderator!) allowing me to scroll through a quite large number (~1000) of dataset by using the up and down arrow keys. The selected data are plotted in the same chart in my worksheet.

I would like to write a macro to save copy of the plots as different images. Then, I'll stack all the images together to build a sort of movie, or an animated gif, by using a third-part software.

Can anyone point me to a macro able to do that or just to some keywords to write it?

Thanks for any help
pagheca

the tip has been really useful. I have been able to write a macro doing what I required.

pagheca