- Sub tt()
- arr = [a1].CurrentRegion
- a = "UserLabel"
- b = "<V i=" & Chr(34) & "14" & Chr(34) & ">"
- Dim brr(1 To 100, 1 To 2)
- For i = 1 To UBound(arr)
- x = arr(i, 1)
- If InStr(x, a) > 0 Then
- na = na + 1
- y = Split(x, a)(1)
- brr(na, 1) = Mid(y, 3, 1)
- End If
- If InStr(x, b) > 0 Then
- nb = nb + 1
- y = Split(x, b)(1)
- brr(nb, 2) = Mid(y, 1, 1)
- End If
- Next
- n = IIf(na > nb, na, nb)
- If n > 0 Then [e2].Resize(n, 2) = brr
- End Sub
复制代码 |