来一个- Sub 示例()
- Dim k, i, j, n, arr, brr(1 To 1000000, 1 To 8)
- arr = Range("a1").CurrentRegion
- For k = 1 To 8
- brr(1, k) = arr(1, k)
- Next
- n = 1
- For k = 2 To UBound(arr)
- For j = 1 To UBound(Split(arr(k, 4), "、")) + 1
- n = n + 1
- brr(n, 1) = arr(k, 1)
- brr(n, 2) = arr(k, 2)
- brr(n, 3) = arr(k, 3)
- brr(n, 4) = Split(arr(k, 4), "、")(j - 1)
- brr(n, 5) = arr(k, 5)
- brr(n, 6) = arr(k, 6)
- brr(n, 7) = arr(k, 7)
- brr(n, 8) = arr(k, 8)
- Next
- Next
- Range("u1").Resize(n, 8) = brr
- End Sub
复制代码 |