Sub aa() Dim arr Dim i As Long For i = 2 To Sheets.Count arr = Sheets(i).Range("B4:F6") Sheet1.Range("B65536").End(xlUp).Offset(1, 0).Resize(3, 5) = arr Next i End Sub
Sub test() Dim xlSht As Worksheet Worksheets("汇总").Range("b4:f65536").ClearContents For Each xlSht In Worksheets With xlSht If .Name <> "汇总" Then .Range("b4:f6").Copy Worksheets("汇总").Range("b65536").End(xlUp).Offset(1, 0) End With Next End Sub
Sub aa() Dim arr Dim i As Long For i = 2 To Sheets.Count arr = Sheets(i).Range("B4:F6") Sheet1.Range("B65536").End(xlUp).Offset(1, 0).Resize(3, 5) = arr Next i End Sub