I have very little experience with VBA in Excel and I'm trying to do a
Monte Carlo simulation. I have the following:


For x = 1 To 10000
Calculate
Range("D2").Select
Selection.Copy
Range("D6").Select
Selection.PasteSpecial Paste:=xlPasteValues
Next x

D2 is the cell where the result from another worksheet is displayed.
This result is derived from some random variables, and after each
calculation the result is different.

D6 is the first cell I want the result from D2 to be copied after the
first calculation, and D7 the result after the second calculation, etc.
etc.

If I change the 5th line with:

Range("D6:D10005").Select

I get the same result 10000 times, and not 10000 different results as I
want. I probably need to use the ARRAY function, but I have no idea how
to use this.