- Sub test()
- Dim arr, arrT, brr, i%, k&, j%
- arr = Sheets("比对信息1").Range("a1").CurrentRegion.Value
- ReDim brr(1 To UBound(arr) * 20, 1 To 4)
- For i = 1 To UBound(arr)
- arrT = Split(arr(i, 4), ",")
- For j = 0 To UBound(arrT)
- k = k + 1
- brr(k, 4) = arrT(j)
- brr(k, 1) = arr(i, 1)
- brr(k, 2) = arr(i, 2)
- brr(k, 3) = arr(i, 3)
- Next j
- Next i
- Sheets("结果").Range("a1").Resize(k, 4) = brr
- End Sub
复制代码 |