Question: I have two columns in excel which i have to merge and put into a third column using arrays. So, I first converted those two
I have two columns in excel which i have to merge and put into a third column using arrays.
So, I first converted those two columns into arrays
ReDim Array1(2 To 23) For i = 2 To 23 Array1(i) = Worksheets("Merge").Cells(i, 1).Value Next i
For j = 2 To 16 Array2(j) = Worksheets("Merge").Cells(j, 3).Value Next j
What do i do next to add those two arrays into a third array(3)?
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
