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