|
楼主 |
发表于 2014-11-1 16:53
|
显示全部楼层
备注答案:http://www.excelpx.com/forum.php ... 977&pid=3792816- Sub demo()
- Dim ar, br(1 To 60000, 1 To 4), m, i, j, n
- ar = Sheet1.Range("a2:b" & Cells(Rows.Count, 1).End(3).Row)
- m = ar(1, 2) - ar(1, 1) - 1
- For i = 1 To UBound(ar)
- For j = 1 To ar(i, 1) + 1
- n = n + 1
- If j = ar(i, 1) + 1 Then
- br(n, 1) = ar(i, 1)
- br(n, 2) = ar(i, 2)
- br(n, 3) = n + m
- br(n, 4) = 0
- Else
- br(n, 1) = ""
- br(n, 2) = ""
- br(n, 3) = n + m
- br(n, 4) = 1
- End If
- Next
- Next
- Range("a2").Resize(n, 4) = br
- End Sub
复制代码 |
|