VBA Code For Copy a Range from Excel and Pasting in PowerPoint, homework help

Hi. I need some help with my VBA code. I am currently using an array for the number of PowerPoint slides and an array setup for the Excel Range to be copied. My issue is that I need to have two ranges selected. When I run the code, it includes all rows not the selected range. I have attached a couple of files for reference. The Excel file is a template of what I am dealing with. There is a header that I need to appear with selected ranges for each slide. In the excel file the Header range is $A$6:$I$8. Slide 1 comes out fine because it is the header and the first level (level 1 in excel file). The following slides include all rows, not the range that I provide. For example ‘List of Excel Ranges to Copy from

MyRangeArray = Array(Sheet1.Range(“$A$6:$I$16”), Sheet1.Range(“$A$6:$I$9”, $A$17:$I33),etc…..and the PowerPoint range is ‘List of PPT Slides to Paste to
MySlideArray = Array(2, 3, 4, 5, 6)…The first slide is Cover Slide, which is why its starting at 2.

The code i based my modified code off of is included in the files. Please help! Is the issue because the array used for the range is all from the same sheet?

Needs help with similar assignment?

We are available 24x7 to deliver the best services and assignment ready within 3-8hours? Order a custom-written, plagiarism-free paper

Get Answer Over WhatsApp Order Paper Now

Do you have an upcoming essay or assignment due?

All of our assignments are originally produced, unique, and free of plagiarism.

If yes Order Paper Now