|
- Sub 合并()
- Dim sht As Worksheet, i&, arr
- For i = 2 To Sheets.Count
- n = n + 1
- With Sheets(i)
- arr = .Range(.Cells(11, 1), .Cells(.Cells(Rows.Count, 1).End(3).Row, "m"))
- End With
- If n = 1 Then
- Sheets("汇总").Cells(4, 1).Resize(UBound(arr), 13) = arr
- Else
- Sheets("汇总").Cells(Rows.Count, 1).End(3).Offset(1, 0).Resize(UBound(arr), 13) = arr
- End If
- Next
- End Sub
复制代码 |
|