snare wrote:
yahoo 字典
感謝樓主補充說明,我修改了一版放上來給大家參考.
可查單字,且可發音.

[點擊下載]
snare wrote:
yahoo 字典

Dylan67 wrote:
感謝joehuang(恕刪)
Arr2 = Split(Arr1(i, 1), "-") '使用 Split 分割欄位
For j = 0 To 2 '寫入列範圍(j = 0,"/"左側字串;j = 1,"/"右側字串)
Cells(i, j + 2).Value = Arr2(j) '將各個欄位填入對應的儲存格
Next j
Dylan67 wrote:
我想請教,怎麼讓Arr1字串拆分後,先全部寫入Arr2後,最後再一次寫進單元格,感謝。
'詳細請參考(Range.TextToColumns 方法)
'https://docs.microsoft.com/zh-tw/office/vba/api/excel.range.texttocolumns
Sub test()
Sheets("test").Columns("A:A").TextToColumns Destination:=Range("B1"), Other:=True, OtherChar:="-"
End Sub
Sub test()
Dim temp(1 To 2000, 2) As String, Arr1, Arr2, i As Integer, j As Integer
With Sheets("TEST")
Arr1 = .Range("A1:A2000")
For i = 1 To UBound(Arr1, 1)
Arr2 = Split(Arr1(i, 1), "-")
For j = 0 To UBound(Arr2)
temp(i, j) = Arr2(j)
Next j
Next i
.Range("b1:d2000") = temp()
End With
End Sub

Dylan67 wrote:
”陣列的數量”是不是有限制。

Dylan67 wrote:
另測試您"陣列"的範例,我發現當從2000筆改成40000筆的時候會出現”溢位”訊息(改成30000筆ok)