|
- Sub Macro1()
- Dim arr, brr(1 To 60000, 1 To 4), i&, s%, n&, zf$
- arr = Sheet1.Range("a1").CurrentRegion
- With CreateObject("vbscript.regexp")
- .Pattern = "\d、.+?\/"
- .Global = True
- For i = 2 To UBound(arr)
- s = 0
- For Each m In .Execute(arr(i, 3))
- n = n + 1: s = s + 1
- brr(n, 1) = arr(i, 1)
- brr(n, 2) = arr(i, 2)
- brr(n, 3) = s
- zf = Split(m, "、")(1)
- brr(n, 4) = Left$(zf, Len(zf) - 1)
- Next
- Next
- End With
- Sheet2.Activate
- ActiveSheet.UsedRange.ClearContents
- [a1:d1] = Array("作者", "类目", "序号", "内容")
- Range("a2").Resize(n, 4) = brr
- End Sub
复制代码 |
|