View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
No Name
 
Posts: n/a
Default Adding space to VBA code

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


.