Printable View
Hi to all,
I have an Excel file with 4 different sheets in it. Each of those sheet contains a chart and i would like to put all those charts in the same one sheet...in a way that i can see all charts (eg. 1/4 page for each chart in this case). I would also have the code to be flexible and work for n number of charts.
TIA
easy to do, loop through all the sheets in the workbook, loop through the charts on each sheet, then copy each chart to the destination sheet, you may need to count the number of charts, to work out the positions on the destination sheet
try recording a macro to copy 1 chart first, then look at removing all references to active anything or selection, working with the full address of the sheet and chart object
then you can work into doing the loops