Thread: Array+Array
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Peter T Peter T is offline
external usenet poster
 
Posts: 5,600
Default Array+Array

One way,

Sub test()
Dim i As Long, e As Long
Dim s As String
Dim arr1, arr2

arr1 = Array(1, 2, 3, 4)
arr2 = Array("A", "B", "C", "D", "E", "F")

e = UBound(arr1) - LBound(arr1) + 1
e = e + UBound(arr2) - LBound(arr2) + 1

ReDim arr3(0 To e - 1)

e = -1

For i = LBound(arr1) To UBound(arr1)
e = e + 1
arr3(e) = arr1(i)
Next

For i = LBound(arr2) To UBound(arr2)
e = e + 1
arr3(e) = arr2(i)
Next

For i = LBound(arr3) To UBound(arr3)
s = s & arr3(i)
Next

Debug.Print s

End Sub

Regards,
Peter T

"Danny" wrote in message
...
Hi,

I have 2 (or more) arrays, how can i combine them into 1?


example:
Array 1 = "1, 2, 3, 4"
Array 2 = "A, B, C, D, E, F"

Result:
Array_Combined = "1, 2, 3, 4, A, B, C, D, E, F"


br,
Danny