I came across this problem while writing a blog post (see post here) that shows how to copy/paste data from Excel to PowerPoint slides. I realized that I was getting errors when I tried to set a variable equal to a newly pasted object in PPT 2013 but in PPT 2007 it worked fine (I don't have 2010 to test with). Below is how I ended up writing my code to handle both versions of PowerPoint but was wondering if this is an error on Microsoft's side or if they changed something for an improvement. Curious if any one else has had this problem or if there is a better way to accommodate 2007-2013 versions of PowerPoint? If you need context, my entire code is posted in the blog post link in the first sentence. Thanks!
'Paste to PowerPoint and position
On Error Resume Next
Set shp = myPresentation.Slides(MySlideArray(x)).Shapes.PasteSpecial(DataType:=2) 'Excel 07-10
Set shp = PowerPointApp.ActiveWindow.Selection.ShapeRange 'Excel 2013
On Error GoTo 0