Hi Everyone, I've done as much of this as I can on my own (and with help from people much smarter than I). I'm a VBA Newbie.
I have an Excel spreadsheet that creates a PowerPoint Presentation. By clicking a button on each sheet, it copies a range or chart to the Presentation (thats currently open) as a picture and adds a title to the slide. This works but...
What I'm trying to do is get it down to just clicking one button and it loops through each sheet that is not hidden, copies the chart and the title and pastes it to a new Slide in PowerPoint without having to go to each sheet and click a button. Kind of like a "Generate PowerPoint" button.
I have gotten it to the point where it loops through and titles each page, but it wont copy the ranges/charts and it places them in backwards, 5,4,3,2,1 instead of 1,2,3,4,5. I'm not sure where the problem lies.
Any help would be great!
Code is below.
Thanks,Please Login or Register to view this content.
John
Bookmarks