|
[广告] VBA代码宝 - VBA编程加强工具 · VBA代码随查随用 · 内置多项VBA编程加强工具 ★ 免费下载 ★ ★ 使用手册★
上面代码稍做优化。
- Sub 统计()
- ar = Range("A7").End(4).Row
- arr = Range("A8:E" & ar)
- Set d = CreateObject("Scripting.Dictionary")
- For i = 1 To ar - 7
- If arr(i, 2) = "上" Then
- m = Range("G2").Value
- n = Range("H2").Value
- Else
- If arr(i, 2) = "单" Then
- m = Range("H3").Value
- n = Range("G3").Value
- End If
- End If
- If arr(i, 5) >= m And arr(i, 5) <= n Then
- d(arr(i, 1) & arr(i, 2)) = d(arr(i, 1) & arr(i, 2)) & "、" & arr(i, 3)
- End If
- Next
- For j = 4 To 5
- Range("G" & j) = Mid(d(Cells(j, "E") & Cells(j, "F")), 2)
- Next
- Set d = Nothing
- End Sub
复制代码 |
评分
-
1
查看全部评分
-
|