|
[广告] VBA代码宝 - VBA编程加强工具 · VBA代码随查随用 · 内置多项VBA编程加强工具 ★ 免费下载 ★ ★ 使用手册★
- a = Left(crr(i, 2), 1): b = Mid(crr(i, 2), 2, 1): c = Right(crr(i, 2), 1)
-
- If brr(a, 2) > brr(b, 2) Then
- If brr(b, 2) > brr(c, 2) Then
- brr(a, 3) = k + 1: brr(b, 3) = k + 2: brr(c, 3) = k + 3: k = k + 3
- ElseIf brr(b, 2) < brr(c, 2) Then
- brr(b, 3) = k + 3
- If brr(a, 2) > brr(c, 2) Then
- brr(a, 3) = k + 1: brr(c, 3) = k + 2: k = k + 3
- ElseIf brr(a, 2) < brr(c, 2) Then
- brr(a, 3) = k + 2: brr(c, 3) = k + 1: k = k + 3
- End If
- End If
- ElseIf brr(a, 2) < brr(b, 2) Then
- If brr(b, 2) < brr(c, 2) Then
- brr(a, 3) = k + 3: brr(b, 3) = k + 2: brr(c, 3) = k + 1: k = k + 3
- ElseIf brr(b, 2) > brr(c, 2) Then
- brr(b, 3) = k + 1
- If brr(a, 2) > brr(c, 2) Then
- brr(a, 3) = k + 2: brr(c, 3) = k + 3: k = k + 3
- ElseIf brr(a, 2) < brr(c, 2) Then
- brr(a, 3) = k + 3: brr(c, 3) = k + 2: k = k + 3
- End If
- End If
- End If
-
-
- If brr(a, 2) = brr(b, 2) Or brr(a, 2) = brr(c, 2) Or brr(b, 2) = brr(c, 2) Then
- brr(a, 3) = k + 1 & "|" & k + 2 & "|" & k + 3
- brr(b, 3) = k + 1 & "|" & k + 2 & "|" & k + 3
- brr(c, 3) = k + 1 & "|" & k + 2 & "|" & k + 3
- k = k + 3
- End If
复制代码
|
评分
-
1
查看全部评分
-
|