- Sub demo()
- Dim ar, br(1 To 1000, 1 To 3), n, i, x, j
- ar = Range("a1:h" & Cells(Rows.Count, 1).End(3).Row)
- For i = 1 To UBound(ar)
- For x = 1 To ar(i, 8)
- n = n + 1
- br(n, 1) = ar(i, 1) & "-" & x
- br(n, 2) = ar(i, 2)
- br(n, 3) = ar(i, 3)
- Next
- Next
- Sheets("sheet2").Range("a2").Resize(n, 3) = br
- Sheets("sheet2").Range("a2").Resize(n, 3).Borders.LineStyle = 1
- End Sub
复制代码 附件楼下
|