Hello,

I actually have 2 issues I am trying to solve. I am taking data and
stacking it on top to have 1 row of data to run correlations.

I have a cell (N_Size) that has the number of rows I want to be
selected starting at D3. I don't know how to reference this named
cell to select the number of rows specified in it.

Next I don't know how to loop this code to repeat X amount of times to
stack the data on top of each other.

So just as an example, I have a 150 in B3 (# of rows wanted to be
selected in D3) and 5 in B5 (# of columns that I want stacked on top
of each other starting with D3). How do I get this to happen in a VBA
code.

Thanks for any help/guidance you can give.

PC

writedata = 5
for RowOff = 0 to Range("B3")
for ColOff = 0 to Range("B5")
Range("D3").offset(rowoffset:=Rowoff,columnoffset:=coloff) = writedata
next Coloff
Rowoff

"(E-Mail Removed)" wrote:

> Hello,
>
> I actually have 2 issues I am trying to solve. I am taking data and
> stacking it on top to have 1 row of data to run correlations.
>
> I have a cell (N_Size) that has the number of rows I want to be
> selected starting at D3. I don't know how to reference this named
> cell to select the number of rows specified in it.
>
> Next I don't know how to loop this code to repeat X amount of times to
> stack the data on top of each other.
>
> So just as an example, I have a 150 in B3 (# of rows wanted to be
> selected in D3) and 5 in B5 (# of columns that I want stacked on top
> of each other starting with D3). How do I get this to happen in a VBA
> code.
>
> Thanks for any help/guidance you can give.
>
> PC
>
>