|
- Sub 汇总()
- Dim sh As Worksheet
- Dim arr, brr(), i&, j%, c&
- For Each sh In Worksheets
- If sh.Name Like "表*" Then
- j = sh.Cells(Rows.Count, 1).End(3).Row
- arr = sh.Range("A2:E" & j).Value
- For i = 1 To UBound(arr)
- c = c + 1
- ReDim Preserve brr(1 To 5, 1 To c)
- For j = 1 To UBound(arr, 2)
- brr(j, c) = arr(i, j)
- Next
- Next
- End If
- Next
- With Sheets("汇总")
- .Range("A2").Resize(c, 5) = Application.Transpose(brr)
- .Sort.SortFields.Clear
- .Sort.SortFields.Add Key:=.Range("A2").Resize(c, 5), _
- SortOn:=xlSortOnValues, Order:=xlAscending, DataOption:=xlSortNormal
- End With
- End Sub
复制代码 晕,刚刚回错帖子了。。。 |
评分
-
查看全部评分
|