|
[广告] VBA代码宝 - VBA编程加强工具 · VBA代码随查随用 · 内置多项VBA编程加强工具 ★ 免费下载 ★ ★ 使用手册★
参与一下。。。- Sub ykcbf() '//2024.3.22
- Set d = CreateObject("Scripting.Dictionary")
- r = Me.Cells(Rows.Count, "u").End(3).Row
- arr = Me.[u4].Resize(r - 3, 18)
- bSort arr, 1, UBound(arr), 1, 18, 18, 2
- For i = 1 To UBound(arr)
- s = arr(i, 1)
- If arr(i, 18) >= 0.5 Then
- If Not d.exists(s) Then
- d(s) = Array(arr(i, 2), arr(i, 3))
- End If
- End If
- Next
- r = Me.Cells(Rows.Count, "a").End(3).Row
- arr = Me.Range("a1:s" & r)
- For i = 4 To UBound(arr)
- s = arr(i, 1)
- If d.exists(s) Then
- arr(i, 18) = d(s)(0)
- arr(i, 19) = d(s)(1)
- End If
- Next
- Me.[r4:s1000] = ""
- Me.Range("a1:s" & r) = arr
- MsgBox "OK!"
- End Sub
复制代码
|
|