|
参与一下。。。
- Sub ykcbf() '//2024.5.13
- Application.ScreenUpdating = False
- Set sh = ThisWorkbook.Sheets("合并")
- On Error Resume Next
- ReDim brr(1 To 10000, 1 To 6)
- For Each sht In Sheets
- If InStr(sht.Name, "期") Then
- With sht
- r = .UsedRange.Find("合计").Row
- arr = .[a1].Resize(r - 1, 6)
- fn = .Name
- End With
- For i = 5 To UBound(arr)
- If Val(arr(i, 1)) Then
- m = m + 1
- brr(m, 1) = fn
- For j = 2 To UBound(arr, 2)
- brr(m, j) = arr(i, j)
- Next
- End If
- Next
- End If
- Next
- With sh
- .UsedRange.Offset(4).Clear
- With .[a5].Resize(m + 1, 6)
- .Value = brr
- .Borders.LineStyle = 1
- .HorizontalAlignment = xlCenter
- .VerticalAlignment = xlCenter
- End With
- r = .Cells(Rows.Count, 1).End(3).Row
- .Cells(r + 1, 4).Resize(1, 3).FormulaR1C1 = "=SUM(R5C:R" & "[-1]C)"
- .Cells(r + 1, 1) = "合并"
- .Cells(r + 1, 1).Resize(1, 3).Merge
- End With
- Application.ScreenUpdating = True
- MsgBox "OK!"
- End Sub
复制代码
|
|