Attached below is part of the code when you click a
command button. This puts the values of the cells into a
word document. My question is I want these values on
different lines but by default it places them all on the
same line. I hope this makes sense.. Can some one help?
Thanks in advance.

Dim mywdRange As Word.Range
Set mywdRange = myDoc.Words(1)
With mywdRange
.Text = Range("G6") & _
Range("G7") & _
Range("G8")
End With

By placing the '&' between each range, you are telling the
routine to put each range together on the same line.

You will probably need to specify each range to be pasted
separately, ie

..text1=Range("G6")
..text2=range("G7")
..text3=range("G8")

Hope this helps

DavidC
-----Original Message-----
Attached below is part of the code when you click a
command button. This puts the values of the cells into a
word document. My question is I want these values on
different lines but by default it places them all on the
same line. I hope this makes sense.. Can some one help?
Thanks in advance.

Dim mywdRange As Word.Range
Set mywdRange = myDoc.Words(1)
With mywdRange
.Text = Range("G6") & _
Range("G7") & _
Range("G8")
End With
.