Paste range to Powerpoint textbox

Hello,

I'm struck trying to get the right syntax for pasting a range (e.g. A1:A5) from the active worksheet to a textbox in a PPT template. Here's what I have so far (opens Powerpoint 2010) but can't get it to paste (text only).

Any thoughts are appreciated.

abousetta

Please Login or Register  to view this content.

Hi,

Are you trying to paste to an existing textbox, or to create one from the paste? For the latter something like this should suffice

Please Login or Register  to view this content.

Thanks. This is very helpful.

My intent was the former (to paste to an existing textbox).

This is now working with the text "Some text" hardcoded into vba but not for the range:

Please Login or Register  to view this content.

abousetta

Got it working... big thanks for all your help.

I created a loop to add the range to a string. Then pasted the string into the textbox.

Please Login or Register  to view this content.

If it's always B1:B5, you might also use

Please Login or Register  to view this content.

Thanks. Good point.

You're welcome. Thank you for the rep.

Anytime brother. Keep up the good work.