Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
make continuous list of days of week without Sunday | Excel Discussion (Misc queries) | |||
how do i make a continuous data table | Excel Discussion (Misc queries) | |||
How do I make letters not show up in a alpha-numeric string? | Excel Worksheet Functions | |||
How do I make this string bold? | Excel Programming | |||
make string variable reference VBA sheet name | Excel Programming |