Is there a way when copying an image from Excel to power-point to have the image auto-size to fit perfectly? Right now, I select the height, width, left, and top. Can this be selected automatically? I am running this macro from Excel.




Code Below:
############################################################################
Set RangeHere = Worksheets(SheetName).Range("A" & ThisCol & ":C" & COlumnFinal)
RangeHere.Copy
DoEvents
On Error GoTo RetryHere1
'Paste to PowerPoint and position
Set myShape = mySlide.Shapes.PasteSpecial(ppPasteEnhancedMetafile)
With myShape
myShape.LockAspectRatio = msoTrue
myShape.Height = 308.16
myShape.Width = 449.28
myShape.Left = 177.12
myShape.Top = 101.52
End With
'Clear The Clipboard
'Application.CutCopyMode = False
############################################################################