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

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