Monte Carlo simulation VBA

[Jason Leung]

I used the Monte Carlo simulation VBA codes provided by JackD's web site and
got a Run Time error '6' overflow message and the debugger pointed to the
fourth last line of the codes i.e. X = (expect - opt) /d.
I had 7 tasks included in the analysis and the project is in-progress. I
used the default 500 times iterations.
Any ideas on how to resolve this please. It is so close to have a successful
run.
Regards

 

[Jason Leung]

I got summary tasks in the project. Although I did not select any of the
summary tasks in my previous test.
When I applied the VBA codes on a project without summary tasks, it is
working like a charm.
Regards

 

[JackD]

Hmmm... shouldn't make a difference. I'll take a look at it next week.