|
楼主 |
发表于 2024-5-7 14:32
|
显示全部楼层
本帖最后由 ning84 于 2024-5-7 15:28 编辑
谢谢回复,琢磨用字典方法,首先计算出重复单元格
set Rng= orng.resiz(重复数,1)
Rng.Union
vba字典重复key_字典(Dictionary),在VBA语言中的应用-CSDN博客
https://blog.csdn.net/weixin_39556811/article/details/111679149
采用字典方法必须要两次循环, Union方法是最佳方法.
- Sub ll()
- Dim Kk As Integer
- Dim Dict As Dictionary
- Set Dict = New Dictionary
- Dim Arr: Arr = Array("bb", "aa", "aa", "bb", "cc", "aa", "bb", "cc", "aa", "bb", "cc", "aa")
- For ii = 0 To UBound(Arr)
- Dict(Arr(ii)) = ""
- Next ii
-
- For ii1 = 0 To Dict.Count - 1
- For ii = 0 To UBound(Arr)
- If Dict.Keys(ii1) = Arr(ii) Then
- Kk = Kk + 1
- 'Debug.Print Kk
- End If
- Next ii
- Debug.Print Dict.Keys(ii1), "///", Kk
- Kk = 0
- Stop
- Next ii1
- End Sub
复制代码
|
|