Notifications
Clear all
VBA & Macros
2
Posts
2
Users
0
Reactions
403
Views
Topic starter
Hi i am using the excel 2013
I activated the excel and PowerPoint with 2 nos empty slides
Sheets "1" and "2" data range copy and paste to PowerPoint
this code paste with image, I need Paste with "Keep Source Formatting"
'Paste to PowerPoint and position
On Error Resume Next
Set shp = myPresentation.Slides(MySlideArray(x)).Shapes.PasteSpecial(DataType:=2) 'Excel 2007-2010
On Error GoTo 0
Please modification this code
thanks for your help
Posted : 05/01/2021 5:49 am
Hi ,
Have you tried this?
http://www.vbaexpress.com/forum/showthread.php?46243-Solved-Retain-Excel-Format-when-pasting-to-PowerPoint
Posted : 06/01/2021 11:26 pm
