Copied Graph Different Size

[Bazman76]

I resized teh graph I am copying from to be much larger than it was originally.

However when I cut and paste it using VBA, the pasted version is back to the original size.

Can I use VBA to force the pasted version to retain the new larger size?

 

[Andrew Poulsom]

I can't reproduce that behaviour, at least in Excel 2003. Can you post your VBA code please?

 

[Bazman76]

I managed to work round it by manually resizing

With ActiveChart.Parent
.Height = x ' resize
.Width = y ' resize
End With

thanks

Baz