First my source looks like this:
I want the 2 sub-ranges (let's say "A3:C6" & "A8:C11") to be pasted on one powerpoint slide side by side. This is for one worksheet. There are 6 such sheets all with same range.
I learnt how to use PageSetup
property to change object dimensions (code posted here) but i'm not able to write a for
loop to paste each sub-range to each corner of a slide. And extend that for
loop to all 6 sheets in my workbook. Can anyone help me please?