|
简单分了一下,看看对不对。- Sub 分列()
- arr = Sheets(1).[a1].CurrentRegion
- ReDim brr(1 To UBound(arr), 1 To 100)
- Rows("2:10000").Clear
- For i = 1 To UBound(arr)
- x = arr(i, 1)
- If Val(x) > 0 Then
- n = n + 1
- c = 4
- brr(n, 1) = Val(x)
- x = Trim(Replace(x, Val(x) & ".", ""))
- brr(n, 2) = Split(x, "[")(0)
- If InStr(x, "[") > 0 Then brr(n, 3) = "[" & Split(x, "[")(1)
- Else
- If InStr(x, ":") > 0 Then
- brr(n, 4) = x
- Else
- c = c + 1
- brr(n, c) = x
- End If
- End If
- Next
- [a2].Resize(n, 10) = brr
- End Sub
复制代码 |
|