Pasting Selected Ranges into a PowerPoint Slides

You will find two attachements to this thread. One is a completed example I found pasting charts into PowerPoint Presentation and the other is my example of what I would like done. Difference here is that I am not using charts, instead I am using selected ranges to paste in a PowerPoint Presentation.

Instead of pasting charts to Excel, I would like to make each colored range a slide in the PowerPoint (Please see attachment).

So by click on the command button "Create PowerPoint Presentation", I would like to have PowerPoint open and the two colored ranges should be in the PowerPoint Presentation as Slide 1 and Slide2.

I have done some research on this topic and found information, but I have not clue as how to do it.

Did you want ranges as slide or Shapes as slides? The 2nd xls has two rectangle shapes.

This example copies 4 ranges as images to slides.

Please Login or Register  to view this content.

This is exactly what I wanted. Now, I know that I may be asking for too much here.
But when the ranges are sent to the PowerPoint Presentation as a picture object, its' size is bigger than the width and height of the PowerPoint slide. Is there a away to create a code that will resize the picture object to automatically fit evenly in the PowerPoint slide?

Please see my new attachment with the problem I am having

"Get an error" and "code does not work" go hand in hand I would think. Obviously it would "error" if you did not set the PowerPoint object reference as I explained. If you want to stick with late binding we can do that of course. Sometimes I do both types of object binding. I will design it with early binding and make the production version late binding so that I don't have to worry about versions of application objects. Sometimes, I use both to get the best of both worlds.

Also, keep in mind what I said about width and height. One will govern the other so order will matter or simply do not use the other. I guess we could make code to decide the matter for us. We might be able to expand the Width or Height but you would loose your scale and it might look odd.

To put the whole range into one slide, I will show the early binding method first and then your late binding last. Basically, you just need that one line for Height in this scenario.

Early Binding:

Please Login or Register  to view this content.

Late Binding:

Please Login or Register  to view this content.

... do all of my user have to set this every time ...

The reference is in the workbook, so no.

One of the (few) advantages of late binding is that it will work for users who have PPT 10 or 12 instead of PPT 11.

Thanks Kenneth and Shg,

I copied and pasted the late binding in the spreadsheet it size the height as it should have, but the width in the PowerPoint Presentation is cutting off a part of the range. Therefore, from Range(s:z) is not showing on the slide. I tried to play around with the code and revise these line

Please Login or Register  to view this content.

But things got worst.

I also reverified that the Range was correct in the code:

Please Login or Register  to view this content.

Nothing happened

What do I need to to adjust the width so that it includes all of the range I have specified?

Also, keep in mind what I said about width and height. One will govern the other so order will matter or simply do not use the other. I guess we could make code to decide the matter for us. We might be able to expand the Width or Height but you would loose your scale and it might look odd.

I know that Kenneth touched on losing scale. Will this still be the case with the Range(A2:Z77)? Is there any other ideas I can use?

Please see the attachement