My question is I want these values on different lines but
by default it places them all on the same line. I am
almost looking for something like in html " &nbsp" or
<br.. I hope I explained this ok.
Thanks in advance.

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

Thank you for your help.

-----Original Message-----
..Text = Range("G6") & vbCrLf & _
Range("G7") & vbCrLf & _
Range("G8")


"John" wrote:

My question is I want these values on different lines
but
by default it places them all on the same line. I am
almost looking for something like in html " " or
<br.. I hope I explained this ok.
Thanks in advance.

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


.