arr1 = Range(Range("C13"), Range("C13").End(xlDown)).Value2
arr2 = Range(Range("E13"), Range("E13").End(xlDown)).Value2
'arr2 = ws.Range("E13:E25").Value2
arr3 = Split(Join(Application.Transpose(arr1), ",") & "," & Join(Application.Transpose(arr2), ","), ",")
'Debug.Print Join(arr3, ",")
Showing posts with label Combine two arrays in one array using vba. Show all posts
Showing posts with label Combine two arrays in one array using vba. Show all posts
Sunday, April 10, 2022
Combine two arrays in one array using vba
Subscribe to:
Posts (Atom)