View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
AA2e72E AA2e72E is offline
external usenet poster
 
Posts: 400
Default Combine Strings into One String

Use x.Selection.TypeParagraph instead of x.Selection.TypeText; also, send
each string separately to Word.

"Adam" wrote:

I need to create a bookmark into Word, but I have all these strings. Is there
a method to combine these strings into one string; however have each string
as a paragraph??

Example Code:
String1 = "All Preparation Work as Stated Above"
x.Selection.TypeText String1 & vbCr

String2 = Worksheets("Bid").Cells(1, 15).Value & " : " & "Apply " &
Worksheets("Bid").Cells(i, 15).Value & " coats interior flat latex paint of
highest quality"
x.Selection.TypeText String2 & vbCr

String3 = Worksheets("Bid").Cells(1, 20).Value & " : " & "Apply " &
Worksheets("Bid").Cells(i, 20).Value & " coats interior flat latex paint of
highest quality"
x.Selection.TypeText String3 & vbCr

Thanks