ExcelBanter - Copy charts and resize

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Copy charts and resize (https://www.excelbanter.com/excel-programming/357247-copy-charts-resize.html)

Joe34

Copy charts and resize

Hi,

I want to copy charts from different excel file to a new excel file by
using VBA.
After I've done this, I want to resize all charts.
How can I do this?
How can I address the copied charts?

Thx.
Joe

All times are GMT +1. The time now is 05:17 PM.