I had another computer that I had this working on, but now I have excel 2013 professional plus and it MIGHT be the issue, although I doubt it.

Anyways can someone tell me what is wrong with my code:

Sub PasteTable()
     
    Dim myShape As Object
     'paste excel table as enhanced metafile, then resize to full width
     
    Set myShape = ActiveWindow.Selection.SlideRange(1).Shapes.PasteSpecial(DataType:=2)
    With myShape
        '.LockAspectRatio = True
        '.Top = 80 'points from top
        '.Left = 10 'points from left
        '.Width = 700 'points wide
    End With
End Sub
Thanks
Mike