Adam,
Record a macro in Word whilst performing your actions. You will something
usable.

NickHK

"Adam" wrote in message
...
String0 = Worksheets("Bid").Cells(1, 2).Value & " : " &
Worksheets("Bid").Cells(i, 2)
so that when it goes to Word that it's formatted correctly?