这是VBA 代码:
Sub copy_range_to_cell()
Set rng = Range("A3:C4")
For Each Column In rng.Columns
For Each cell In Column.Cells
Range("E4").Value = Range("E4").Value & cell.Text & Chr(10)
Next cell
Range("E4").Value = Range("E4").Value & Chr(10)
Next Column
End Sub
前:
后: