Post table from excel to powerpoint NOT as picture

jconnol8

New Member
Joined
Jun 7, 2013
Messages
1
Hi all,

I am trying to copy a table from excel to powerpoint. I just want it to paste the same way that it does when I just hit Ctrl-V on my computer, but my code(below) keeps throwing an error unless I paste as a picture, or an OLE object. I don't want it linked, and I need to be able to modify the table in ppt. Any ideas? I've been struggling with this for a while now. Thanks!





Object1Name = Worksheets("Sheet" & i).Cells(6, 3)
'Set Object1 = Range(Object1Name)
Range(Object1Name).Copy


slide(3).Shapes.PasteSpecial ppPasteOLEObject, msoFalse, , , , msoFalse
 

Excel Facts

Waterfall charts in Excel?
Office 365 customers have access to Waterfall charts since late 2016. They were added to Excel 2019.

Forum statistics

Threads
1,225,644
Messages
6,186,153
Members
453,339
Latest member
Stu61

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top