Mashing up Text from lots of cells. My way is ugly and time consuming. Is there a better way?

[fishoutofwater]

I have a bunch of outputs in a column. I am trying to tunr all the text in all those cells into a paragraph in another cell. The way I have been doing it is this:

ScriptGen!N205&ScriptGen!N206&ScriptGen!N207&ScriptGen!N208&ScriptGen!N209&ScriptGen!N210&ScriptGen!N211&ScriptGen!N212&ScriptGen!N213&ScriptGen!N214&ScriptGen!N215&ScriptGen!N216&ScriptGen!N217&ScriptGen!N218&ScriptGen!N219&ScriptGen!N220&ScriptGen!N221&ScriptGen!N222&ScriptGen!N223&ScriptGen!N224&ScriptGen!N225&ScriptGen!N226&ScriptGen!N227&ScriptGen!N228&ScriptGen!N229&ScriptGen!N230&ScriptGen!N231&ScriptGen!N232&ScriptGen!N233&ScriptGen!N234&ScriptGen!N235&ScriptGen!N236

This is just basically mashing up every cell from N205 through N236 into one cell. The problem is building this long instruction line is soooooo slow. Is there a better way to put in cell A1: "Hey, mash-up all the output from N205 all the way through N236" that doesn't require me hand tying "&" 29 times?

 

[jeffreybrown]

See if this does it for you...

http://www.mrexcel.com/forum/showthread.php?t=573585

or

http://www.excelforum.com/excel-gen...a-from-multiple-cells-in-one-single-cell.html

 

[Jaye7]

This works also.

Sub test1()
Range("N205:N236").Select

Dim cell As Range
For Each cell In Selection.Cells
If cell.HasFormula = False Then
End If
ActiveCell.Offset(1, 0).Select
Range("N204").Value = Range("N204").Value & ActiveCell.Value
    
Next
range("N204").select
End Sub