down multiple cells

  1. M

    Loop down rows on multiple selected cells

    I have a sub that will join the text together from multiple columns into one cell but it only works for one row. I would like it to work through the rows selected. How do I do this? Sub JoinText() myCol = Selection.Columns.Count For i = 1 To myCol ActiveCell = ActiveCell.Offset(0, 0) &...

Some videos you may like

This Week's Hot Topics