|
参与一下。。。
- Sub ykcbf() '//2024.5.7
- Application.ScreenUpdating = False
- With Sheets("报表管理")
- nf = CLng(.OLEObjects("ComboBox1").Object.Value)
- yf = CLng(.OLEObjects("ComboBox2").Object.Value)
- .[b3].Value = "统计区间:" & nf & "年" & yf & "月"
- End With
- With Sheets("数据表")
- r = .Cells(Rows.Count, 1).End(3).Row
- arr = .[a1].Resize(r, 10)
- End With
- ReDim brr(1 To UBound(arr), 1 To 8)
- For i = 2 To UBound(arr)
- rq = CLng(arr(i, 2))
- If Year(rq) = nf And Month(rq) = yf Then
- m = m + 1
- brr(m, 1) = m
- For j = 4 To UBound(arr, 2)
- brr(m, j - 2) = arr(i, j)
- Next
- End If
- Next
- With Sheets("报表管理")
- If m > 0 Then
- .UsedRange.Offset(4).ClearContents
- .UsedRange.Offset(4).UnMerge
- .[b5].Resize(m, 8) = brr
- r = m + 5
- .Cells(r, 2) = "合计"
- .Cells(r, 8).FormulaR1C1 = "=SUM(R5C:R" & "[-1]C)"
- .Cells(r, 2).Resize(1, 6).Merge
- .[b5].Resize(m + 1, 8).Borders.LineStyle = 1
- Else
- MsgBox "无相应记录!"
- Exit Sub
- End If
- End With
- Application.ScreenUpdating = True
- MsgBox "OK!"
- End Sub
复制代码
|
评分
-
1
查看全部评分
-
|