|
发表于 2015-3-15 23:22
|
显示全部楼层
本楼为最佳答案
- Sub Macro1()
- Dim rng As Range, arr, d, i&, s&, j%
- Set d = CreateObject("scripting.dictionary")
- Sheet1.Activate
- Sheet2.[a:a] = ""
- Set rng = Application.InputBox("请用鼠标选中数据区域", Type:=8)
- If rng.Count < 2 Then Exit Sub
- arr = rng
- For i = 1 To UBound(arr)
- For j = 1 To UBound(arr, 2)
- d(arr(i, j)) = d(arr(i, j)) + 1
- If d(arr(i, j)) = 2 Then s = s + 1: Sheet2.Cells(s, 1) = arr(i, j)
- Next
- Next
- Sheet2.Activate
- End Sub
复制代码 |
|