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.

Please Login or Register  to view this content.

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:

Please Login or Register  to view this content.

Thanks for the help yudlugar.

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