Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Displaying results of loop in cells
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF formula results not displaying | Excel Worksheet Functions | |||
Displaying how many results in a vlookup | Excel Discussion (Misc queries) | |||
Displaying formula rather than results... | Excel Discussion (Misc queries) | |||
functions are not displaying the results | Excel Worksheet Functions | |||
Excel VBA - Cells Counting using VBA codes and displaying results in msg box | Excel Programming |