Data Copied To Word - Move Cursor Down One Line

[Chubski]

Hello,

I've got a macro that copies multiple data to word which works fine but once the data is pasted each time I want to have the word document (controlled by Excel) to move down one line so that when the next item of data is pasted there is a one line space.

So far the only other option is to have it copy over an extra line from Excel but there must be a better way to achieve this as not all the items that are copied and pasted will want a space after them.

Any ideas gratefully received.

Regards

C

 

[Trevor G]

You can work out the code to add into your Excel Sub routine by recording a Macro in Word to do the paste and then press enter. You would see that it says you are adding TypeParagraph. So by recording and pressing enter on a Word document to get the extra line it would show you.

Selection.TypeParagraph
Selection.TypeParagraph

 

[Chubski]

Trevor,

Many thanks for the help.

That works for me and also helped me with moving on my project for something else.

Regards

C