View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
john john is offline
external usenet poster
 
Posts: 97
Default Adding space to VBA code

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