Hello,
Very amateur VB user, need help!
I need to write VB code to concatenate the data in 100 or more cells into a
single string. This is easy for a small number of cells:
ActiveCell.Offset(0, 0).FormulaR1C1 = _
ActiveCell.Offset(0, -1) & "," & ActiveCell.Offset(0, -2) etc.
But how do I do this without needing to type the "ActiveCell.Offset" 100
times? Is there any way to included a for/next loop within the concatenation?
Thanks!
/LJ
Bookmarks