如何在VBA（Excel）中遍历行

假设您的数据看起来像这样（颜色可以更容易地显示组）：

以下代码将每个组（黄色，绿色）粘贴到“结果”列中。

码：

Option Explicit

Sub copy_paste()

Dim lrow As Long
Dim i As Long
Dim j As Long

Dim ws As Worksheet
Set ws = ActiveWorkbook.Worksheets("Sheet1") 'Set the name of the sheet

lrow = ws.Cells(Rows.Count, "A").End(xlUp).Row 'Find the last row in column A

For i = 2 To lrow Step 13 'Loop every group (group of 13 rows) in column A
    For j = 1 To 13 Step 13 'For each group, copy and paste
        ws.Cells(i, "A").Resize(13).Copy ws.Cells(Rows.Count, "D").End(xlUp).Offset(1, 0) 'Copy the group and paste it to the column D. Offset by one to not overwrite the last row
        ws.Cells(i, "B").Resize(13).Copy ws.Cells(Rows.Count, "D").End(xlUp).Offset(1, 0)
        ws.Cells(i, "C").Resize(13).Copy ws.Cells(Rows.Count, "D").End(xlUp).Offset(1, 0)
    Next j
Next i

End Sub

结果：