skip to Main Content
The smarter way
to do assignments.

Please note that this is just a preview of a school assignment posted on our website by one of our clients. If you need assistance with this question too, please click on the Order button at the bottom of the page to get started.

Question description

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 fromMyRangeArray = 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 toMySlideArray = 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?


Clicking on this button will take you to our custom assignment page. Here you can fill out all the additional details for this particular paper (grading rubric, academic style, number of sources etc), after which your paper will get assigned to a course-specific writer. If you have any issues/concerns, please don't hesitate to contact our live support team or email us right away.

How It Works        |        About Us       |       Contact Us

© 2018 | Intelli Essays Homework Service®

Back To Top