Yes, you are on the right track. However, I am looking for more of an automated loop with an option to prompt me as to how many repititions to be made. I would probably want to run thousands.
After making this request, I noticed that here appears to be something suspiciously wrong with the random generator. This only becomes appearent when running millions of iterations. The "total number of hands" should be more or less the same from Ace to 9 with the face cards being 4 times this amount. However, after running this maybe a dozen times manually at 10 million iterations, 6 had the fewest amount of hands each time. This cannot be possible. Not sure if you are familiar with randon generators as well or if perhaps someone else could look at the code and see what (if anything) is wrong with the way the numbers are generated. Thanks for the effort - much appreciated. On Apr 6, 11:36 pm, ashish koul <koul.ash...@gmail.com> wrote: > see if it helps > > > > > > On Wed, Apr 6, 2011 at 11:03 PM, RON SMITH <comeonove...@gmail.com> wrote: > > Here is the file: > > > On Wed, Apr 6, 2011 at 7:01 AM, qcan <comeonove...@gmail.com> wrote: > > >> Hi, > > >> I have this great Monte Carlo Simulation program for blackjack. I am > >> not all that good in VBA, but would like a small macro to run this > >> program, the copy and paste the results to another sheet, then repeat > >> that task again for as many times as I wish. > > >> Any takers ? I can forward the spreadsheet to you as I cannot seem to > >> attach it here. > > >> Thanks. > > >> -- > > >> ---------------------------------------------------------------------------------- > >> Some important links for excel users: > >> 1. Follow us on TWITTER for tips tricks and links : > >>http://twitter.com/exceldailytip > >> 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310 > >> 3. Excel tutorials athttp://www.excel-macros.blogspot.com > >> 4. Learn VBA Macros athttp://www.quickvba.blogspot.com > >> 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com > > >> To post to this group, send email to excel-macros@googlegroups.com > > >> <><><><><><><><><><><><><><><><><><><><><><> > >> Like our page on facebook , Just follow below link > >>http://www.facebook.com/discussexcel > > > -- > > > ---------------------------------------------------------------------------------- > > Some important links for excel users: > > 1. Follow us on TWITTER for tips tricks and links : > >http://twitter.com/exceldailytip > > 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310 > > 3. Excel tutorials athttp://www.excel-macros.blogspot.com > > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com > > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com > > > To post to this group, send email to excel-macros@googlegroups.com > > > <><><><><><><><><><><><><><><><><><><><><><> > > Like our page on facebook , Just follow below link > >http://www.facebook.com/discussexcel > > -- > *Regards* > * * > *Ashish Koul* > *akoul*.*blogspot*.com <http://akoul.blogspot.com/> > *akoul*.wordpress.com <http://akoul.wordpress.com/> > My Linkedin Profile <http://in.linkedin.com/pub/ashish-koul/10/400/830> > > P Before printing, think about the environment. > > MonteCarlo(1).xls > 153KViewDownload- Hide quoted text - > > - Show quoted text - -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel