Thread: [Solved] Paste shape from Excel
View Single Post
 
Old 03-03-2020, 08:47 AM
jeffreybrown jeffreybrown is offline Windows 10 Office 2016
Expert
 
Join Date: Apr 2016
Posts: 613
jeffreybrown has a spectacular aura aboutjeffreybrown has a spectacular aura about
Default Paste shape from Excel

I'm taking a shape from Excel and would like to fill the slide in ppt.

This below is fine, but how can it stretch from the left to the right?

Code:
    With PPSlide
        .Shapes.Paste.Select
        With .Shapes(.Shapes.Count)
            .LockAspectRatio = msoTrue
            .Left = 15
            .Top = 100
            .Height = 400
        End With
Reply With Quote