Did you have one of the charts selected?
The code will apply the width/height of the currently selected to chart
to all the others on the sheet.

crossingmind wrote:
Thank you so much Andy. The latter way worked well. The first way I met
a bug on the line
sngWidth = ActiveChart.Parent.Width
Don't know how to debug it. Could you help more? Thanks a lot!


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info