本帖最后由 qh8600 于 2014-12-19 20:15 编辑
- Sub demo()
- Dim ar, br()
- ar = Range("a1").CurrentRegion
- ReDim br(1 To 60000, 1 To UBound(ar, 2))
- For x = 1 To UBound(ar, 2) Step 2
- For i = 1 To UBound(ar)
- If ar(i, x) = ar(2, x) Then
- n = n + 1
- For j = 1 To UBound(ar, 2)
- br(n, j) = ar(i, j)
- Next
- End If
- Next
- n=n+1
- Next
- Sheets("sheet2").Range("a1").Resize(n, UBound(br, 2)) = br
- End Sub
复制代码 附件楼下
|