Adding space to VBA code

[John]

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

 

[Guest]

Thank you for your help.

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



.