|
- Sub 容错输出()
- bw = Join(Application.Transpose(Application.Transpose([b1:k1])), "") '百位
- sw = Join(Application.Transpose(Application.Transpose([b2:k2])), "") '百位
- gw = Join(Application.Transpose(Application.Transpose([b3:k3])), "") '个位
- Dim arr(1 To 1000, 1 To 3)
- cmin = [n2]: cmax = [p2] '最大最小错误数
- For i = 0 To 999
- a = i \ 100
- b = (i - a * 100) \ 10
- c = i Mod 10
- cw = 3 + (InStr(bw, a) > 0) + (InStr(sw, b) > 0) + (InStr(gw, c) > 0) '错误数
- If cw >= cmin And cw <= cmax Then
- n = n + 1
- arr(n, 1) = a: arr(n, 2) = b: arr(n, 3) = c
- End If
- Next
- [a11:c1100] = ""
- If n > 0 Then [a11].Resize(n, 3) = arr
- MsgBox "共有" & n & "组"
- End Sub
复制代码 |
本帖子中包含更多资源
您需要 登录 才可以下载或查看,没有帐号?注册
x
评分
-
查看全部评分
|