|
- Sub test()
- Dim ws As Worksheet
- Dim r%, i%
- Dim arr
- With Worksheets("汇总")
- .UsedRange.Offset(1, 0).Delete
- End With
- For Each ws In Worksheets
- If ws.Name <> "汇总" Then
- With ws
- .UsedRange = .UsedRange.Value
- r = .Cells(.Rows.Count, 1).End(xlUp).Row
- arr = .Range("a4:f" & r - 1)
- For i = 1 To UBound(arr)
- arr(i, 6) = ws.Name
- Next
- With Worksheets("汇总")
- r = .Cells(.Rows.Count, 1).End(xlUp).Row
- .Cells(r + 1, 1).Resize(UBound(arr), UBound(arr, 2)) = arr
- End With
- End With
- End If
- Next
- With Worksheets("汇总")
- r = .Cells(.Rows.Count, 1).End(xlUp).Row
- arr = .Range("a2:a" & r)
- For i = 1 To UBound(arr)
- arr(i, 1) = i
- Next
- .Range("a2:a" & r) = arr
- .Range("a1:f" & r).Borders.LineStyle = xlContinuous
- End With
- End Sub
复制代码 |
评分
-
1
查看全部评分
-
|