循环改递归
For Y1 = 0 To b(2)
For Y2 = 0 To b(3)
For Y3 = 0 To b(4)
For Y4 = 0 To b(5)
For Y5 = 0 To b(6)
For Y6 = 0 To b(7)
For Y7 = 0 To b(8)
For Y8 = 0 To b(9)
For Y9 = 0 To b(10)
For Y10 = 0 To b(11)
For Y11 = 0 To b(12)
For Y12 = 0 To b(13)
For Y13 = 0 To b(14)
For Y14 = 0 To b(15)
For Y15 = 0 To b(16)
For Y16 = 0 To b(17)
For Y17 = 0 To b(18)
For Y18 = 0 To b(19)
For Y19 = 0 To b(20)
If Sheet1.Cells(2, 2) - (Y0 * a(1) + Y1 * a(2) + Y2 * a(3) + Y3 * a(4) + Y4 * a(5) + Y5 * a(6) + Y6 * a(7) + Y7 * a(8) + Y8 * a(9) + Y9 * a(10) + Y10 * a(11) _
+ Y11 * a(12) + Y12 * a(13) + Y13 * a(14) + Y14 * a(15) + Y15 * a(16) + Y16 * a(17) + Y17 * a(18) + Y18 * a(19) + Y19 * a(20)) < Sheet1.Cells(2, 3) And _
Sheet1.Cells(2, 2) - (Y0 * a(1) + Y1 * a(2) + Y2 * a(3) + Y3 * a(4) + Y4 * a(5) + Y5 * a(6) + Y6 * a(7) + Y7 * a(8) + Y8 * a(9) + Y9 * a(10) + Y10 * a(11) _
+ Y11 * a(12) + Y12 * a(13) + Y13 * a(14) + Y14 * a(15) + Y15 * a(16) + Y16 * a(17) + Y17 * a(18) + Y18 * a(19) + Y19 * a(20)) >= 0 Then
w = w + 1
Sheet2.Cells(w, 2) = Y0
Sheet2.Cells(w, 3) = Y1
Sheet2.Cells(w, 4) = Y2
Sheet2.Cells(w, 5) = Y3
Sheet2.Cells(w, 6) = Y4
Sheet2.Cells(w, 7) = Y5
Sheet2.Cells(w, 8) = Y6
Sheet2.Cells(w, 9) = Y7
Sheet2.Cells(w, 10) = Y8
Sheet2.Cells(w, 11) = Y9
Sheet2.Cells(w, 12) = Y10
Sheet2.Cells(w, 13) = Y11
Sheet2.Cells(w, 14) = Y12
Sheet2.Cells(w, 15) = Y13
Sheet2.Cells(w, 16) = Y14
Sheet2.Cells(w, 17) = Y15
Sheet2.Cells(w, 18) = Y16
Sheet2.Cells(w, 19) = Y17
Sheet2.Cells(w, 20) = Y18
Sheet2.Cells(w, 21) = Y19
Sheet2.Cells(w, 22) = w - 1
Sheet2.Cells(w, 23) = Sheet1.Cells(2, 2) - (Y0 * a(1) + Y1 * a(2) + Y2 * a(3) + Y3 * a(4) + Y4 * a(5) + Y5 * a(6) + Y6 * a(7) + Y7 * a(8) + Y8 * a(9) + Y9 * a(10) + Y10 * a(11) _
+ Y11 * a(12) + Y12 * a(13) + Y13 * a(14) + Y14 * a(15) + Y15 * a(16) + Y16 * a(17) + Y17 * a(18) + Y18 * a(19) + Y19 * a(20))
Sheet2.Cells(w, 24) = "x" + Str(w - 1)
End If
Next Y19
Next Y18
Next Y17
Next Y16
Next Y15
Next Y14
Next Y13
Next Y12
Next Y11
Next Y10
Next Y9
Next Y8
Next Y7
Next Y6
Next Y5
Next Y4
Next Y3
Next Y2
Next Y1
Next Y0
相关推荐
易语言改前N位文件名源码-易语言
易语言改前N位文件名源码
JavaScript的递归之递归与循环示例介绍
递归与循环 对于不同类型的需要重复计算的问题,循环和递归两种方法各有所长,能给出更直观简单的方案。另一方面,循环和递归的方法可以互相转换。任何一个循环的代码都可以用递归改写,实现相同的功能;反之亦然。在不失去其普遍性的前提下,可以把循环和递归分别用下列伪代码概括。 伪代码格式说明:循环采用while形式;变量不加定义;赋值用:=;条件表达式和执行的语句都写成函数的形式,圆括号内写上相关的值。其他语法方面,尽量接近Javascript的规范。 代码如下: //pseudo code of a loop //while形式 function loop(arguments){ //结果的初始值 r
Python 树的遍历递归和循环
class TreeNode(object): def __init__(self, x): self.val = x self.left = None self.right = None ###递归的形式 先序遍历 中序遍历 后序遍历 def preOrderRecursive(root): if root == None: return None print(root.val) preOrderRecursive(root.left) preOrderRecursive(root
Java 跳出递归循环问题解决办法
主要介绍了 Java 跳出递归循环问题解决办法的相关资料,需要的朋友可以参考下
循环赛日程表(分治递归法)
循环赛日程表是非常典型的分治递归的例子,也的一个稍微有点难的问题。但是,我相信大家一定没问题


VB基础类

