本帖最后由 sd2605061 于 2016-7-20 13:49 编辑
Sub 拆分()
Dim arr(), brr(1 To 100, 1 To 3), i As Integer, j As Integer, k As Integer, m As Integer, iRows As Integer
Range("G6,L6,Q6") = 1
iRows = Range("C6").CurrentRegion.Rows.Count
Range("G6,L6,Q6").ClearContents
arr = Range("C6:U" & iRows + 6)
For j = 1 To UBound(arr, 2)
If arr(1, j) = "数据" Then
k = k + 1
For i = 2 To UBound(arr, 1)
If arr(i, j) = "" Then Exit For
For m = 1 To 3
brr(i - 1, m) = Mid(arr(i, j), m, 1)
Next m
Next i
Cells(7, 5 * k - 1).Resize(iRows, 3) = brr
Erase brr
End If
Next j
End Sub