|
327086276 发表于 2011-3-30 13:43
回复 放浪形骸 的帖子
忽然发现,您把老大年纪定为了19岁,我最初意思是说老大小于20岁,也就是说老大的年 ...
哦,这样的啊,我帮你修改下吧。
- Sub CountAge()
- Dim iBig As Integer
- Dim iMid As Integer
- Dim iSml As Integer
- Dim iRow As Integer
- Cells(1, 1) = "大哥年龄"
- Cells(1, 2) = "二哥年龄"
- Cells(1, 3) = "小弟年龄"
- Cells(1, 4) = "年龄乘积"
- iRow = 2
- For iSml = 1 To 19
- For iMid = iSml + 1 To 19
- For iBig = iMid + 1 To 19
- Cells(iRow, 1) = iBig
- Cells(iRow, 2) = iMid
- Cells(iRow, 3) = iSml
- Cells(iRow, 4) = iBig * iMid * iSml
- iRow = iRow + 1
- Next
- Next
- Next
- End Sub
复制代码
OutPut2.zip
(6.61 KB, 下载次数: 2)
|
|