VBA - Printing/fitting multiple charts on a page

Hello,

I have a worksheet with a lot of charts (~32). I have written a code to size these charts to have the same dimensions and align them with 3 charts in each row.

My problem is that i want to setup a macro to size the charts so i can print 6 charts (2 rows with 3 charts) on a page (page setup should be Landscape)

How will i go about setting the right size of the charts? And how to set the margins etc for the page?


Thanks in advance

//Rasmus