Rameez Sarang
Member
Hi,
I am running a Macro in excel which copies the data and pastes it in a PPT which has 17 slides. Since there is continuous copy-paste action performed by the macro, it sometimes gives a debug error in between(couples of times) as it cant copy the data that fast, but when when I click on debug and run it again it performs the action and completes the ppt correctly.
Is there a code which can be inserted to avoid the debug error as large amount on data is getting pasted in PPT from excel continuously.
I have attached the excel Macro file + the ppt template + the how the final ouput(PPT should look like).
I am getting lots of debug error while running this but when I click on debug and run it again it works.
Also for Slide - 6,8 & 10, I want the table to be pasted as Sourceformatting from excel so that it can be editable but when I do so the excel rows and columns outlines get captured in ppt which I dont want. Please can anyone help on this as well.
Please help.
Thanks
I am running a Macro in excel which copies the data and pastes it in a PPT which has 17 slides. Since there is continuous copy-paste action performed by the macro, it sometimes gives a debug error in between(couples of times) as it cant copy the data that fast, but when when I click on debug and run it again it performs the action and completes the ppt correctly.
Is there a code which can be inserted to avoid the debug error as large amount on data is getting pasted in PPT from excel continuously.
I have attached the excel Macro file + the ppt template + the how the final ouput(PPT should look like).
I am getting lots of debug error while running this but when I click on debug and run it again it works.
Also for Slide - 6,8 & 10, I want the table to be pasted as Sourceformatting from excel so that it can be editable but when I do so the excel rows and columns outlines get captured in ppt which I dont want. Please can anyone help on this as well.
Please help.
Thanks