|
发表于 2013-7-30 17:44
|
显示全部楼层
本楼为最佳答案
Private Sub CommandButton1_Click()
Dim arr, brr, name
Dim i, j
Dim d
arr = Sheets("Sheet1").Range("A1:A" & Sheets("Sheet1").Cells(Rows.Count, 1).End(3).Row)
Set d = CreateObject("scripting.dictionary")
ReDim brr(1 To UBound(arr), 1 To 2)
For i = 1 To UBound(arr)
d(arr(i, 1)) = d(arr(i, 1)) + 1
Next
name = d.keys
For i = 0 To UBound(name)
If d(name(i)) > 1 Then
j = j + 1
brr(j, 1) = name(i)
brr(j, 2) = d(name(i))
End If
Next
Sheets("Sheet2").Range("C:D").ClearContents
Sheets("Sheet2").Range("C1").Resize(j, 2) = brr
End Sub
关键问题用红色标出来了。 |
评分
-
查看全部评分
|