In section 25.2 we designed a macro which calculates the value of using Monte Carlo and
Question:
In section 25.2 we designed a macro which calculates the value of π using Monte Carlo and which updates the screen every iteration. Modify the macro so that it updates the screen only every 1,000 iterations.
• Use the VBA function Mod . From the VBA help menu, note that this function has syntax a Mod b. (A similar Excel function has syntax Mod(a,b), but cannot be used in VBA.)
• Use the VBA commands Application.ScreenUpdating = True and Application. ScreenUpdating = False to control the updating of the screen.
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Related Book For
Question Posted: