Paste from Excel to specific row and column in Powerpoint table

gpb237

New Member
Joined
Oct 27, 2015
Messages
25
The idea is to select a specific row and column in a table within PowerPoint and paste values from excel or from the clipboard.
I cannot get the macro to paste what I have already copied from the clipboard into the selected cells in the table.
I cannot get the macro to link to excel when I'm in a Powerpoint table. Seems like VBA is averse to ppt tables. The macro works fine up until I try to paste. Any thoughts?
Here is part of what I've written.

Sub Macro1 ()
Dim PowerpointApplication As Object, PowerpointPresentation As Object, PowerpointSlide As Object
Dim PowerpointTextbox As Object

ThisWorkbook.Sheets("Data for Powerpoint").Range("A4").Copy
PowerpointPresentation.Slides(1).Select
PowerpointSlide.Shapes("Table1").Table.Rows(2).Cells.Item(1).Select

Paste from clipboard or create link to excel???

End Sub
 

Some videos you may like

Excel Facts

Select all contiguous cells
Pressing Ctrl+* (asterisk) will select the "current region" - all contiguous cells in all directions.

Watch MrExcel Video

Forum statistics

Threads
1,095,875
Messages
5,447,009
Members
405,428
Latest member
Cad67

This Week's Hot Topics

Top