|
- Sub 转换()
- arr = Range("a1:a" & [a65536].End(3).Row)
- ReDim brr(1 To UBound(arr), 1 To 2)
- brr(1, 2) = "正确答案"
- ss = "一二三四五六七八九十"
- For i = 1 To UBound(arr)
- x = Replace(Replace(arr(i, 1), "(", "("), ")", ")")
- If x Like "*题(*" Then '题大类
- s1 = s1 + 1
- s2 = 0
- n = n + 1
- x = Split(x, "每")(0)
- x = Mid(ss, s1, 1) & "、" & Left(x, Len(x) - 1) & ")"
- brr(n, 1) = x
- ElseIf InStr(x, "()") Or InStr(x, "( )") Then '题干
- n = n + 1
- s2 = s2 + 1
- brr(n, 1) = s2 & "、" & x
- For k = i + 1 To UBound(arr)
- y = arr(k, 1)
- If Not y Like "正确答案*" Then
- If y = "正确" Then y = "A.正确"
- If y = "错误" Then y = "B.错误"
- brr(n, 1) = brr(n, 1) & Chr(10) & y
- Else
- brr(n, 2) = Replace(Mid(y, 6), ",", "")
- If brr(n, 2) = "正确" Then brr(n, 2) = "A"
- If brr(n, 2) = "错误" Then brr(n, 2) = "B"
- Exit For
- End If
- Next
- End If
- Next
- Sheets(3).[a1].Resize(n, 2) = brr
- End Sub
复制代码 |
评分
-
查看全部评分
|