Sub AwTest()
Dim i&, j%, k&, c&, r&, n&, zf$, arr, rng As Range, Iscolor As Boolean
Sheet1.Activate
arr = [a1].CurrentRegion
ReDim brr(1 To 5000, 1 To UBound(arr, 2))
Rem 准备从[A1]单元格输出
For j = 1 To UBound(arr, 2)
r = 0: Iscolor = False
For i = 1 To UBound(arr)
zf = Trim(arr(i, j)): k = Len(zf)
If k > 0 Then
Iscolor = Not Iscolor
For c = 1 To k
r = r + 1
brr(r, j) = Mid(zf, c, 1)
If Iscolor = False Then
If rng Is Nothing Then
Set rng = Cells(r, j)
Else
Set rng = Union(rng, Cells(r, j))
End If
End If
Next
End If
Next
n = IIf(n > r, n, r)
Next
[a:z].Clear
[a1].Resize(n, UBound(brr, 2)) = brr
If Not rng Is Nothing Then rng.Interior.Color = 15986394
End Sub |