Hi

I have a macro which pastes a range of data (table) from a worksheet to a ppt slide. It goes as follows:

Worksheets(SheetName).Range(CellRange).Copy
ppSlide.Shapes.Paste.Select
ppApp.ActiveWindow.Selection.ShapeRange.Top = 100
It gives me an automation error on the red line. However instead of simply ppSlide.Shapes.Paste.Select, if I use
ppSlide.Shapes.PasteSpecial(ppPasteEnhancedMetafile).Select
I get no error. However I want to do a simple paste so that I can modify the table in powerpoint also. Please tell me what I am doing wrong.