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 blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!