VBA to copy Excel data range and paste in PowerPoint text boxes

[palaniappan0212]

Hello,

I do not have much knowledge in VBA programming but would like to automate a repetitive task that I am doing every week.

I need to copy a range of cells (horizontal/vertical range) with its font color from Excel and then paste them into PowerPoint Text boxes.

I am currently manually copying each Excel cell and then pasting as values in each PPT textbox which is very time consuming and exhaustive, making my work prone to errors.

If any of you VBA experts know of a simple code to achieve this, I kindly request you to share it with me.

Thanks in advance for your amazing help

 

[Trevor G]

Read this thread

powerpoint - copy text from Excel cell to PPT textbox - Stack Overflow