I currently have a spreadsheet that has an infinate number of rows determined
by the user.
The code states:
For row=7 to Worksheets('Example').UsedRange.Row.Count
String1 = Worksheets("Example").Cells.(Row,1).Value
Endfor
Now I am trying to accomplish it to just add to the string opposed to just
creating a new line each time. This information is finally outputted to Word.
For example: What I want
Column
Apples
Oranges
Peaches
to look like: Apples, Oranges, Peaches
What I get:
Apples, Oranges, Peaches
Apples, Oranges
Apples
is the current output. Any suggestions? Thanks
Bookmarks