- Sub test()
- Dim rg As Range, r As Integer
- arr = Array("A", "B", "C", "D", "E", "对", "错")
- r = 2
- t = 0
- start = 0
- For i = 1 To 154
- If InStr(1, Sheets(1).Range("a" & i), ".") > 0 And _
- InStr(1, Sheets(1).Range("a" & i), "A.") = False And _
- InStr(1, Sheets(1).Range("a" & i), "B.") = False And _
- InStr(1, Sheets(1).Range("a" & i), "C.") = False And _
- InStr(1, Sheets(1).Range("a" & i), "D.") = False And _
- InStr(1, Sheets(1).Range("a" & i), "E.") = False And _
- InStr(1, Sheets(1).Range("a" & i), "F.") = False Then
- Sheets(2).Range("d" & r) = Sheets(1).Range("a" & i) '找题目
-
- ss = Sheets(2).Range("d" & r)
-
- If InStr(1, ss, "(") > 0 Then
- ks = InStr(1, ss, "(")
- Else
- ks = 1
- End If
-
- For Each a In arr
- If InStr(ks, ss, a) > 0 Then
- If start = 0 Then start = InStr(ks, ss, a)
- t = t + 1
- End If
- Next a
-
- On Error Resume Next
- Sheets(2).Range("e" & r) = Mid(ss, start, t) '找abcde
- On Error GoTo 0
- t = 0
- start = 0
-
-
-
- r = r + 1
- End If
- Next i
- End Sub
复制代码
写了半天只能转换题目和ABCDE ,后面太麻烦我也不会弄了 |