|
发表于 2013-7-27 12:25
|
显示全部楼层
本楼为最佳答案
高版本打不开,你先试试以下代码,已根据你的说明作了修改- Private Sub CommandButton1_Click()
- Dim arr, i&, j&, d As Object, c
- Set d = CreateObject("scripting.dictionary")
- arr = Range("b2:b" & [b65536].End(3).Row)
- j = 1
- For i = 2 To UBound(arr)
- d(arr(i, 1)) = d(arr(i, 1)) + 1
- Next i
- For Each c In d.KEYS
- If d(c) = 1 Then d.Remove (c)
- Next c
- MsgBox Join(d.KEYS, ",")
- End Sub
复制代码 |
|