|
[广告] VBA代码宝 - VBA编程加强工具 · VBA代码随查随用 · 内置多项VBA编程加强工具 ★ 免费下载 ★ ★ 使用手册★
- Sub 按钮1_Click()
- Application.ScreenUpdating = False
- r = Cells(Rows.Count, 1).End(3).Row
- arr = [a1].Resize(r + 1, 3)
- sm = arr(2, 3)
- x = 0
- r = 1
- For j = 2 To UBound(arr) - 1
- If arr(j, 1) <> arr(j + 1, 1) Then
- r = r + 1
- arr(r, 2) = arr(j, 2)
- arr(r, 1) = arr(j, 1) & "-" & x
- arr(r, 3) = sm
- sm = 0
- x = 0
- Else
- If sm + arr(j + 1, 3) > 35 Then
- r = r + 1
- arr(r, 2) = arr(j, 2)
- arr(r, 1) = arr(j, 1) & "-" & x
- arr(r, 3) = sm
- sm = arr(j + 1, 3)
- x = 0
- Else
- sm = sm + arr(j + 1, 3)
- End If
- End If
- Next j
- arr(1, 3) = "公斤数"
- [k1].Resize(r, UBound(arr, 2)) = arr
- Application.ScreenUpdating = True
- End Sub
复制代码 |
评分
-
1
查看全部评分
-
|