|
本帖最后由 hwc2ycy 于 2013-1-27 22:53 编辑
- Sub 提取2()
- Dim shtHz$
- Dim iRow&
- Dim arr, arr2()
- Dim i&, j&, k&, iRow2&, l&
- With Worksheets("合并")
- iRow = .Cells(Rows.Count, "j").End(xlUp).Row
- If iRow < 6 Then Exit Sub
- arr = .Range("j6:j" & iRow)
- End With
- ReDim arr2(1 To UBound(arr) , 1 To 1)
- iRow = UBound(arr)
- Stop
- For i = 1 To UBound(arr) \ 36
- For j = 1 To 6
- For k = 1 To 6
- iRow2 = i * 36 - 36 + j + k * 6 - 6
- If iRow2 > iRow Then GoTo quit
- l = l + 1
- arr2(l, 1) = arr(iRow2, 1)
- Next
- Next
- Next
- quit:
- With Worksheets("汇总")
- .Range("j:j").ClearContents
- .Range("j6").Resize(l) = arr2
- End With
- MsgBox "提取完成"
- End Sub
复制代码 |
|