返回列表 上一主題 發帖

如何把兩個Array合併?

如何把兩個Array合併?

除了這個麻煩辦法外
  1. Sub abc()
  2. Dim a(), b(), c(), i
  3. a = Array("Tony", "Garnett")
  4. b = Array("Allen", "Pierce", "Bryant")
  5. ReDim Preserve c(UBound(a) + UBound(b) + 1)
  6. For i = 0 To UBound(a)
  7. c(i) = a(i)
  8. Next
  9. For i = 0 To UBound(b)
  10. c(i + UBound(a) + 1) = b(i)
  11. Next
  12. End Sub
複製代碼
有沒有快捷方法處理?
80 字節以內
不支持自定義 Discuz! 代碼

回復 2# GBKEE
  1. Sub combine_array_GBKEE()
  2. Dim a(), b(), c As Variant, d(), i As Integer, j As Integer
  3. a = Array("Tony", "Garnett")
  4. b = Array("Allen", "Pierce", "Bryant")
  5. c = Join(a, ",") & "," & Join(b, ",")

  6. i = UBound(Split(c, ","))
  7. ReDim Preserve d(i)
  8. For j = 0 To i
  9. d(j) = Split(c, ",")(j)
  10. Next

  11. End Sub
複製代碼
已經略作修改,完成了
多謝各位指導
80 字節以內
不支持自定義 Discuz! 代碼

TOP

        靜思自在 : 站在半路,比走到目標更辛苦。
返回列表 上一主題