|
- Sub tt()
- [c3:m15].Clear
- [d20:h29].Copy [d3]
- arr = [c3:m12]
- For i = 1 To 10
- arr(i, 1) = i
- arr(i, 7) = "-": arr(i, 8) = "-"
- x = arr(i, 3)
- If InStr(x, "3F") Or InStr(x, "4F") Or InStr(x, "5F") Then arr(i, 9) = "-": arr(i, 10) = "-"
- If InStr(x, "7G") Or InStr(x, "8G") Then arr(i, 11) = "-": [K15] = "E"
- If InStr(x, "1X") Then [C15] = "A"
- If InStr(x, "2X") Then [E15] = "B"
- If InStr(x, "3X") Then [G15] = "C"
- If InStr(x, "4X") Then [I15] = "D"
- Next
- [c3:m12] = arr
- End Sub
复制代码 |
|