VBA 数据字典练习

最新推荐文章于 2024-05-31 14:22:35 发布

Lee_AA

最新推荐文章于 2024-05-31 14:22:35 发布

阅读量618

点赞数

文章标签：开发语言

本文链接：https://blog.csdn.net/DOYOUUNDERSTANDME/article/details/124586750

版权

Sub zidian()
Dim Dic, arr, arr2, arr3, arr4, Dic1, Dic2
Set Dic = CreateObject("scripting.dictionary")
Set Dic1 = CreateObject("scripting.dictionary")
Set Dic2 = CreateObject("scripting.dictionary")
maxh = Range("A65536").End(xlUp).Row
arr = Range("A2:K" & maxh).Value
For i = 1 To UBound(arr)
If Dic.exists(arr(i, 1)) Then
    Dic1(arr(i, 1)) = Dic1(arr(i, 1)) + 1
    Dic(arr(i, 1)) = Dic.Item(arr(i, 1)) & " " & Dic1(arr(i, 1)) & "、" + arr(i, 11)
    Dic2(arr(i, 1)) = Dic2.Item(arr(i, 1)) & " " & Dic1(arr(i, 1)) & "、" + arr(i, 10)
Else
    Dic1(arr(i, 1)) = 1
    Dic(arr(i, 1)) = "1、" + arr(i, 11)
    Dic2(arr(i, 1)) = "1、" + arr(i, 10)
    
End If
Next
arr2 = Dic.keys
arr3 = Dic.items
arr4 = Dic2.items
Dic.RemoveAll
Dic1.RemoveAll
Dic2.RemoveAll
Set Dic = Nothing
Set Dic1 =