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

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.