Hi all,

I'm trying to export a number of graphs (as gifs) from a single worksheet.

I was planning to automatically name them sequentially i.e. export1.gif, export2.gif etc, based on their position on the worksheet.

I've tried using the index property to export the charts, however there are a couple of charts near the bottom of the sheet that have a lower index number than those above, so they come out in the wrong order.

I believe the index property is read only, which I guess means I can't re-index them in the correct order......Is there another way to do this ?

Thanks

Wibsy