|
本帖最后由 14116518 于 2014-10-14 17:25 编辑
这个问题不知道怎么说,上传附件,请老师抽空给瞧瞧,先谢了
14116518 发表于 2014-10-14 16:41
难道是我没表达清楚意思 - Sub demo()
- Dim arr, x As Long, brr(1 To 1000, 1 To 1), crr(1 To 1000, 1 To 1), i As Long, j As Long
- x = Sheets("表一").Cells(Rows.Count, 1).End(xlUp).Row
- arr = Sheets("表一").Range("a2:c" & x)
- For i = 1 To UBound(arr)
- For j = 1 To arr(i, 3)
- n = n + 1
- brr(n, 1) = arr(i, 1)
- crr(n, 1) = arr(i, 2)
- Next
- Next
- Sheets("表二").Range("b3").Resize(n, 1) = brr
- Sheets("表二").Range("h3").Resize(n, 1) = crr
- End Sub
复制代码
请教.rar
(16.04 KB, 下载次数: 3)
|
|