- Sub x()
- Dim ar, x, k, k1, ar1, arr, ar2(1 To 10000, 1 To 4)
- With Sheets("目标结果")
- .Columns("a:d").Clear
- arr = Range("a2").CurrentRegion
- For x = 1 To UBound(arr)
- ar = Split(arr(x, 3), "、")
- ar1 = Split(arr(x, 4), "/")
- For k = 0 To UBound(ar)
- k1 = k1 + 1
- ar2(k1, 1) = arr(x, 1): ar2(k1, 2) = arr(x, 2)
- ar2(k1, 3) = ar(k): ar2(k1, 4) = ar1(k)
- Next
- Next
- .[a1].Resize(k1, 4) = ar2
- .UsedRange.Borders.LineStyle = 1
- MsgBox "分列完毕"
- .Select
- End With
- End Sub
复制代码 |