- Sub demo()
- Dim ar, br(), m, x, i, n, s
- m = Sheets.Count - 1
- ReDim br(1 To 10000, 1 To m * 4)
- For x = 1 To m + 1
- If Sheets(x).Name <> "Sheet0" Then
- s = s + 1: n = s * 4 - 3
- ar = Sheets(x).Range("a1:q" & Sheets(x).Cells(Rows.Count, 1).End(3).Row)
- For i = 1 To UBound(ar)
- br(i, n) = ar(i, 3)
- br(i, n + 1) = ar(i, 11)
- br(i, n + 2) = ar(i, 17)
- Next
- End If
- Next
- Sheets("Sheet0").Range("a1").Resize(UBound(br), UBound(br, 2)) = br
- End Sub
复制代码 附件楼下
|