I have two arrays as below and I want to merge them into one. How can I do that?
Thank You.
Code:
Dim vArray() As Variant
Dim vArray1() As Variant
vArray = oXLSheet.Range("E12:E140").Value
vArray1 = oXLSheet.Range("U12:U140").Value
cboOperation.Clear
For lngRow = LBound(vArray, 1) To UBound(vArray, 1)
If Not IsEmpty(vArray(lngRow, 1)) Then
cboOperation.AddItem vArray(lngRow, 1)
End If
Next lngRow
For lngRow = LBound(vArray1, 1) To UBound(vArray1, 1)
If Not IsEmpty(vArray1(lngRow, 1)) Then
cboOperation.AddItem vArray1(lngRow, 1)
End If
Next lngRow
Thank You.