|
发表于 2015-9-27 05:30
|
显示全部楼层
本楼为最佳答案
本帖最后由 dsmch 于 2015-9-27 05:39 编辑
- Sub Macro1()
- Dim arr, brr, i&, j%, s%
- Sheet2.UsedRange.ClearContents
- Const n% = 9
- arr = Sheet1.Range("K10").CurrentRegion
- For i = 1 To UBound(arr)
- s = 0
- For j = UBound(arr, 2) - n + 1 To UBound(arr, 2)
- If arr(i, j) = 1 Then s = s + 1
- Next
- If s = n Then
- s2 = s2 + 1
- Sheet1.Rows(i + 9).Copy Sheet2.Cells(s2, 1)
- End If
- Next
- End Sub
复制代码
|
|