|
肯定对不齐啊。呵呵
是展开的嘛
只有能对齐的对齐咯
- Sub 示例()
- Dim arr, brr(1 To 10000, 1 To 1), k, i, sr, n
- arr = Range("A1:A" & Cells(Rows.Count, 1).End(3).Row)
- For k = 1 To UBound(arr)
- If arr(k, 1) = "" Then
- n = n + 1
- brr(n, 1) = ""
- ElseIf InStr(arr(k, 1), ":") = 0 Then
- n = n + 1
- brr(n, 1) = Mid(Mid(arr(k, 1), 2, 10), 1, Len(Mid(arr(k, 1), 2, 10)) - 1)
- Else
- sr = Mid(Mid(arr(k, 1), 2, 10), 1, Len(Mid(arr(k, 1), 2, 10)) - 1)
- For i = VBA.Split(sr, ":")(0) To VBA.Split(sr, ":")(1) Step -1
- n = n + 1
- brr(n, 1) = i
- Next
- End If
-
- Next
- Range("d1").Resize(n, 1).ClearContents
- Range("d1").Resize(n, 1) = brr
- End Sub
复制代码 |
|