Looping the rows of an Array into a one range of rows repeatedly

Hey everyone,

I was hoping if I could get help with an issue. I want to be able to take a data array (two dimensions) and be able to only copy one row. This is part of a much bigger project, but I'm just getting trouble getting going on this issue so i figured asking smaller questions may get me somewhere rather than overwhelming people.


I have something like this for taking the data from an array (arvar). However, I want to be able to replace the existing, first line. So basically, i want to copy row by row, as I am doing now, but I want that to replace the first row. Should I be using a Resize? right now it effectively just duplicates this. I need it to copy the whole row of data, and then

So my desired end result is to paste continuously rows of a two dimensional array on the SAME, set range. so basically: x,x,x,x,x,x,x,x, would then become y,y,y,y,y,y,y,y and then z,z,z,z,z,z,z, etc. The ideas would be the new values replace the old.

Set arvar as Variant

'dim1 is the total number of rows in the two dimensional array (i.e. dimension one)
'dim2 is the total number of columns (i.e. dimension two)


For i = 1 To dim1
    Range("L4").Select
    'I thought that if set it back to the original Range it may copy over. I was worngn 
    For j = 1 To dim2
    
    Range("L4").Cells(i, j) = arvar(i, j)
    
    Next j
Next i

Any help would be much much appreciated. This is one step that would help me to tackling the much bigger issue I described earlier :

http://www.excelforum.com/excel-prog...ake-place.html

Not sure I fully understand the problem but I'm guessing the bit that is "moving" the row you are working on is:
Range("L4").Cells(i,j) as i will increase through your row counter and keep moving to a new row. I'd guess what you need is more like:

For i = 1 to dim1
for j = 1 to dim2
cells(4,12+j) = arvar(i,j)
next j
next i

Thanks for the help yudlugar.

of course, I just need to hold one of the cell dimensions constant...Getting there little by little.