Thanks for the reply Justin.

I apologize as I cannot post the worksheet due to work rules.

I will try to explain in details.

Cell C28 is input by the user. Lets say it has a value of 100.

Line 9 of the code will subtract " i " from 100 = 99.9. This is my first assumed value of AB9 for the first iteration.

Line 11 will divide AB9 by 2 = 49.95. This is my first assumed value of AB4 for the first iteration.

The worksheet can now solve itself using these values and generate values from formulas that are placed in cells AB17 and AB12.

These newly generated values in AB17 and AB12 are replaced in place of AB9 and AB4, respectively, and are the new assumed values of the second iteration (Line 15-24 of the code).

This process in looped until the error criteria is met which is placed in cell AB20 = ABS( (AB17-AB9) + (AB12-AB4)). Basically i want to match AB17 with AB9 and AB12 with AB4. This way the solution would have converged.

Now being that the formulas are complicated, sometimes they evaluate a #NUM! or #DIV/0! resulting in a type 13 mismatch error. What I want is whenever this error occurs, it will go to the error handler which adds 0.1 to i = 0.2 and go back to the beginning in which new values of AB9 and AB4 are placed.

Line 9 of the code will subtract " i + 0.1 " from 100 = 99.8. i + 0.1 due to the error handler code.

Line 11 will divide AB9 by 2 = 49.9.

and the whole process is repeated until AB20 is satisfied.

I hope this makes it clearer. Thanks for the help.