Error handler in simulation

[NikolajNK]

Hi,

I am trying to put in an error handler in a simulation of currency prices. I simulate 10,000 times and use a worksheet function which from time to time gives an run time error due to a too large number being drawn for input, so when that happens I want the simulation to draw a new number and try again from the same simulation step. Any ideas how to do this?

[cytop]

More info on error handling.

If the program errors with an overflow (Error number 6) then just assign a new number and resume

Please Login or Register  to view this content.