Question qbout some very basic commands to help run simulation

Hi there - sorry I am a total beginner and have tried to work this out by Googling, but my VBA code doesn't work!

I have written an excel spreadsheet to count the number of landings on each square on a monopoly board. Runs successfully for a single iteration and I want to run it say 10000 times, each time refreshing the spreadsheet, and reading and adding the values in for each of the 40 cells containing my results. Finally, I want to write the result in the results section of my spreadsheet. I will start by just trying this for a single cell and then I can add the other 39 cells later.


What I have so far is this [and my square bracketed comments are just my comments not the code]:

Please Login or Register  to view this content.

I know this is very basic stuff, but I am a beginner so would really appreciate some help. Thanks in advance.

Wouldn't you want to tackle the whole problem in one go?

I'm not sure if i have what you want correct but this basically plays a game of monopoly with 10,000 dice rolls and tells you how many times it landed on each cell in A1 to A40

Please Login or Register  to view this content.

edit :
OK I get its not what you want (not clear what you need - maybe basic help with how the cells(1,1) and range("A1") work?).. but just for fun
done with an array that is populated once an then returns the values from the array (so that they add up to 10,000 unlike if you ran the iterations sperately).

Format Monopoly(the_tile_number)

Please Login or Register  to view this content.