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

palaniappan0212

New Member
Joined
Aug 13, 2015
Messages
5
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 :)
 

Some videos you may like

Excel Facts

Square and cube roots
The =SQRT(25) is a square root. For a cube root, use =125^(1/3). For a fourth root, use =625^(1/4).

Watch MrExcel Video

Forum statistics

Threads
1,100,140
Messages
5,472,751
Members
406,835
Latest member
steve43040

This Week's Hot Topics

Top