|
本帖最后由 qh8600 于 2015-4-12 09:17 编辑
- Sub demo()
- Dim ar, br(), i, j, n
- x = Cells(Rows.Count, 1).End(3).Row
- ar = Range("a1:a" & x)
- ReDim br(1 To 47 * x, 1 To 1)
- For i = 2 To 48
- For j = 1 To UBound(ar)
- n = n + 1
- br(n, 1) = ar(j, 1) + i
- Next
- Next
- Range("b1").Resize(n, 1) = br
- End Sub
复制代码 附件楼下,楼主试试
|
|