Copy Excel Range to PPT

[undergraduate]

Hello, I have a variable number of slides, and I would like to copy the range A1:G100 to its own pppt slide from each sheet. However, I dont want it copied as a picture rather it should be editable. I have attached code I have found by Andy Pope but still having trouble as it only copies as a picture and I cannot specify the range.

Please Login or Register  to view this content.

[undergraduate]

Hi, I was able to figure the above out!

I have one last question.
Right now the following code is cycling through all my worksheets in my workbook and creating separate presentations of 1 slide each. However, I would like it to only create one presentation with all the slides combined, using the initial slide as a template.

Would really appreciate help with this as its sort of time sensitive. Thank You.

Please Login or Register  to view this content.