Exporting mulitple pages on a Worksheet to PowerPoint using VBA

**ruttiii** · 06-05-2012, 08:17 AM

I'm currently trying to create a VBA-code that will let me copy multiple pages from an Excel-worksheet (set-up via Set Print Area) to a new PowerPoint presentation.
Where every page from that one Excel-worksheet is one slide. I'm currently experimenting with this code:

Please Login or Register  to view this content.

Now the code only makes a picture of one unique range of every worksheet. I want a pictures of multiple pages from one specific worksheet.

For Example, I need a PowerPoint slide of Worksheet1!, Range A1:P41, A42:P82, A83:P143, etc.

Can someone help me out?

Already thanks!

**Chippy** · 06-05-2012, 10:24 AM

Originally Posted by ruttiii

For Example, I need a PowerPoint slide of Worksheet1!, Range A1:P41, A42:P82, A83:P143, etc.

Just change the loop start to:

Please Login or Register  to view this content.

**ruttiii** · 06-05-2012, 10:38 AM

When I insert your code into mine, it says it misses an Next statement?

Could you show me how your could should be implemented in mine?

Thanks!

**Chippy** · 06-06-2012, 06:38 AM

Here is your code modified as required in the way I suggested:

Please Login or Register  to view this content.

This uses ActiveSheet, so just change that to the required sheet name, as shown in my first post.

**ruttiii** · 06-07-2012, 03:57 AM

Originally Posted by Chippy

Here is your code modified as required in the way I suggested:
This uses ActiveSheet, so just change that to the required sheet name, as shown in my first post.

Extremely awesome, it's working like a charm! Thanks a thousand!