Copy & Paste Excel Shapes and Charts into Powerpoint

  • Hi,


    I am trying to figure out how I can copy and paste all objects from a worksheet (including charts) onto a single Powerpoint slide and loop through sheets 1-4 (my sheets are named as "1", "2", "3", "4"). All content from sheet 1 should be pasted on slide 1 in the powerpoint, sheet 2 to slide 2 and so on. Copied objects should be pasted with paste special as pictures.


    Here is my current code which pastes each chart onto an individual slide. Appreciate if I can get some help to adapt this to work as described above.