|
发表于 2015-7-22 11:12
|
显示全部楼层
本楼为最佳答案
完全用原代码- Sub 不重复()
- Dim rg1 As Range, rg2 As Range
- Dim D, RG As Range
- Dim x$
- Set rg1 = Application.InputBox("请选择数据源区域。本次操作将会筛选出数据区的不重复项,存于另指定位置。", "如有疑问,请联系作者", "$A$1:$B$4", , , , , 8)
- Set D = CreateObject("scripting.dictionary") '-----------字典的应用语句
- Set rg2 = Application.InputBox("请选择结果存放区域。", "如有疑问,请联系作者", "$D$1", , , , , 8)
- ReDim arr(1 To 1, 1 To rg1.Count * 2)
- N = 1
- For Each RG In rg1
- x = Trim(RG.Value)
- If D.exists(x) Or x = "" Then '判断数组元素arr1(x,1)在字典关键词里是否存在,
- Else '如果关键词arr1(x,1)不存在,那么
- arr(1, N) = x
- D(x) = N
- N = N + 2
- End If
- Next RG
- rg2.Cells(1, 1).Resize(1, N - 2) = arr
- End Sub
复制代码 |
|