Macro to Paste Series of Monte Carlo Trials

[greg_gr]

Dear Excel Forum:

I've created Monte Carlo simulaiton, based upon a randomn number generator, and currently have the range(T8:AG8) displyaing summary statistics for a particular trial. The overall objective remains to develop a Macro looping the Monte Carlo sim "n" times, while dynamically developing a list of the previous trail statistics. My hope would be to gerate a list similar to the included screen-shot (please see link).

http://www.screencast.com/users/gros...0-ed2129b1c8e0

However, while I have not yet attempted to loop the Macro, the VBA coding does not apear correct to past the values from (T8:AG8), while preserving the forumlas in the range, to an increasngly offset row below.

Any thoughts on how I could solve this or perform the operation more efficiently? I appreciate the help!

[shg]

Welcome to the foru, greg.

Please take a few minutes to read the forum rules, and then edit your post to add CODE tags.

Thanks.