|
- Sub Macro1()
- Dim arr, d, j%, i&
- Set d = CreateObject("scripting.dictionary")
- Sheets(1).Activate
- [a:j] = "": n = 1: sl = [l1]
- For j = 2 To Sheets.Count
- With Sheets(j)
- arr = .Range("a1:i" & .Range("a65536").End(xlUp).Row + 3)
- p = 1
- For i = 2 To UBound(arr) - 1
- If arr(i, 1) = "" And (arr(i + 1, 1) <> "" Or i = UBound(arr) - 1) Then p = p & "," & i
- If arr(i, 1) = "" And arr(i - 1, 1) = "" Then
- s = s + 1
- d(s) = p: p = i + 1
- End If
- Next
- For Each m In d.items
- x = Split(m, ",")
- If UBound(x) >= sl Then
- For i = UBound(x) - 4 + 1 To UBound(x)
- .Range(.Cells(x(i - 1), 1), .Cells(x(i), "I")).Copy Cells(n, 1)
- n = Range("a65536").End(xlUp).Row + 1
- Next
- Cells(n - 1, "j") = .Name
- n = n + 2
- End If
- Next
- End With
- d.RemoveAll
- Next
- End Sub
复制代码 |
评分
-
查看全部评分
|