Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.

How to make excel macro self-repeat for X-Length run?

I would like to know how to make my Excel Macro repeat itself for a specific amount of times, usually 1000 or 1248 times.

It is copying final numbers from one worksheet (running a Monte Carlo Simulation) and pasting them into a second (composite) worksheet. One Macro insert a new row in the composite worksheet, pastes the data and copies formulas up from the row below it. A Second Macro does the same as the first, except it also changes 1 or 2 of the variables entered into the simulation worksheet, based off of a pre-made list (copies the new variables into the proper positions) and then runs just the same as the first.

The simulation worksheet has fixed random number cells, and receives variable numbers from a third or fourth worksheet to set the parameters of the simulation. It also incorporates native formula cells that have no direct influence on other cells only to the simulation results, or initial parsing of the data.

The composite worksheet after data is pasted sums, averages and normalizes the data depending on its nature using formulas native to that worksheet only.

Update:

All I am would like for the macro to do, is just run the exact same process it has been made for a pre-determined number of times.

2 Answers

Relevance
Still have questions? Get your answers by asking now.