執行0.015秒如圖片,請測試看看,謝謝
Sub test()
Dim Arr, Brr(1 To 10000, 1 To 1), a, R&, n&, i&, j&
Tm = Timer
R = Columns("A:C").Find("*", , , , , 2).Row
Arr = Range("a1:c" & R)
For j = 1 To UBound(Arr, 2): For i = 1 To UBound(Arr)
a = Split(Arr(i, j), " ")
For k = 0 To UBound(a)
n = n + 1: Brr(n, 1) = a(k)
Next
Next i: Next j
Range("e1").Resize(n, 1).NumberFormatLocal = "@"
Range("e1").Resize(n, 1) = Brr
MsgBox Timer - Tm
End Sub