|
代码里有,好好研究。
负数变量:df(x) = df(x) + sl
负数变量对应的行(i是行数) ddf(x) = ddf(x) & "," & i
负数变量对应的行转成数组:frr = Split(ddf(x), ",")
数组从大到小排序:
For i = 1 To UBound(frr) - 1 '负值数量从大到小排序
For j = i + 1 To UBound(frr)
If arr(frr(i), 10) < arr(frr(j), 10) Then tmp = frr(i): frr(i) = frr(j): frr(j) = tmp
Next
Next
看懂了吗? |
|