Screenshot a range of cells and paste picture into PowerPoint.

[ESEM1966]

Hi there,

I have seen posts on how to screenshot a full page from Excel into a PowerPoint presentation. Which works as expected. I am very new to VBA and cannot figure out how to select a range and paste the range into PPT.

Any pointers?

Thanks
ESEM

 

[Domenic]

To copy a specific range as a picture . . .

    Range("A1:C5").CopyPicture appearance:=xlScreen, Format:=xlPicture

To paste it into your slide . . .

    pptSlide.Shapes.Paste

Hope this helps!