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 "  " 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 |
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 . |
All times are GMT +1. The time now is 03:37 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com