|
- Private Sub CommandButton1_Click()
- Dim arr, brr(), d As Object, i&, s&, x%, y&, zf$
- Set d = CreateObject("scripting.dictionary")
- Sheets("2").UsedRange.Clear
- For y = 0 To 2
- For y1 = 0 To 2
- With Sheets("1")
- arr = .Range(.Cells(1 + 23 * y, 1 + 16 * y1), .Cells(22 + 23 * y, 11 + 16 * y1)).Value
- End With
-
- ReDim brr(1 To UBound(arr), 1 To UBound(arr, 2))
- For i = 1 To UBound(arr)
- zf = Join(Application.Index(arr, i, 0), ",")
- d(zf) = d(zf) + 1
- If d(zf) = 2 Then
- s = s + 1
- For x = 1 To UBound(arr, 2)
- brr(s, x) = arr(i, x)
- Next
- End If
- Next
- Sheets("2").Cells(1 + 9 * y, 1 + y1 * 16).Resize(s, UBound(brr, 2)) = brr
- s = 0
- d.RemoveAll
- Next
- Next
- End Sub
复制代码 |
|