|
发表于 2014-4-28 13:44
|
显示全部楼层
本楼为最佳答案
好多以前做过。。。。。- Private Sub CommandButton1_Click()
- Set d = CreateObject("scripting.dictionary")
- Sheets("2").UsedRange.ClearContents
- For y = 1 To 4
- r = IIf(y <= 2, 1, 255)
- c = IIf(y Mod 2 = 1, 1, 15)
- arr = Sheet1.Cells(r, c).Resize(253, 9)
- ReDim zff(1 To UBound(arr, 2))
- ReDim brr(1 To UBound(arr), 1 To UBound(arr, 2))
- For i = 1 To UBound(arr)
- N = 0
- For k = 1 To UBound(arr, 2)
- zff(k) = arr(i, k)
- Next
- zf = Join(zff, ",")
- d(zf) = d(zf) + 1
- Next
- dk = d.keys: dt = d.items
- For i = 0 To UBound(dk)
- If dt(i) = 1 Then
- s = s + 1
- For x = 1 To UBound(arr, 2)
- brr(s, x) = Split(dk(i), ",")(x - 1)
- Next
- End If
- Next
- r1 = IIf(y <= 2, 1, 128)
- Sheets("2").Cells(r1, c).Resize(s, 9) = brr
- s = 0
- d.RemoveAll
- Next
- End Sub
复制代码 |
|