excel - Copying and Pasting the Results of a Loop calculation using VBA -

I have a VBA calculation that is looping to repeat the cells 500 (or walk) times. There is an output for each recalculation which I want to record after the loop is completed. I have tried a few different ways, but I do not think this is right. Here is an example that I have so far. Dimensional change in the form of integer, I change the Iteration range ("C14, C15, C16, C17, C18, Copy Category (" J "and" Rows ") for I = 1 as integer change = range (" C4 ") .xlUp) .Offset (1) Select Paste Special xlPasteValues ​​Next I End Sub

Try it:

  Private command command button 1_Click () Dynamic variation in the form of integer variation in the form of the variable V = the range ("C4 "Iteration range for I = 1 (" C14, C15, C16, C17, C18, C19, C20 "). Val = Range (" C20 ") Calculate Valuel. Print" I: "& amp; & amp;" Val: "& Val Range (" J "and Rows.Count). End (xlpe). Offset (1) = val next I and sub  

if the right value is instant window, the problem is elsewhere. Obviously, if the code works as expected, then Delete the debug.print statement.