Thanks Sergey,

I tried that yesterday but the code didn't work for me. I wasn't getting any shapes in the spreadsheet when I checked the shapes.count.


>Would this help http://peltiertech.com/Excel/ChartsHowTo/ResizeAndMoveAChart.html ?
>
>>
>>thanks for your help, I am now much closer. I have one thing that is stopping me now. I need to resize the chart so it displays properly in Word. I guess I have two options to resize it in Excel, or to resize it in Word. Unfortunately I cannot work out how to do this in either one using automation.
>>
>>I am unable to record a macro in either one as when the Macro recording starts, I am unable to select the chart.
>>
>>I am using Office 2002 for this.