|
本帖最后由 qh8600 于 2014-6-1 08:58 编辑
张雄友 发表于 2014-6-1 08:47
如果 B24,C24单元格为空,则[c1].End(4) 怎么改?=24*23*23=12696 - Sub demo() '如果 B24,C24单元格为空,则[c1].End(4) 怎么改?=24*23*23=12696
- Dim ar, br, cr, dr(1 To (24 * 23 * 23), 1 To 3)
- ar = [a1:a24]
- br = [b1:b23]
- cr = [c1:c23]
- For i = 1 To 24 '循环数组ar ,ar有24行所以1 to 24,或者1 to ubound(ar)
- For j = 1 To 23 '循环数组br,br有23行所以 1 to 23,
- 或者1 to ubound(br)
- For k = 1 To 23 '循环数组cr,cr有23行所以 1 to 23 ,
- 或者1 to ubound(cr)
- n = n + 1
- dr(n, 1) = ar(i, 1)
- dr(n, 2) = br(j, 1)
- dr(n, 3) = cr(k, 1)
- Next
- Next
- Next
- Range("m1").Resize(n, 3) = dr
- End Sub
复制代码 3个循环的组合总计是24*23*23=12696
|
评分
-
查看全部评分
|