Hello,

I have a fairly large Excel file. The main output number is calculated using an iterative calculation. I have used VBA to automatically enable iterative calculations (although I am not positive of the proper maximum iterations and maximum change numbers to use). My Excel document uses dynamic data, however, and regularly still gives a divide by zero error. Users of the document are having issues.

If I go to the cell in question, click on the formula bar, and click "Enter," the problem is solved. But, I can't figure out how to do that with VBA. I tried to record a macro, but that does not seem to work. Here is what I have tried:

    ActiveWorkbook.Worksheets("Output").Range("H47").Select
    ActiveCell.FormulaR1C1 = "=SUM(R[-9]C:R[-1]C)"
    Application.Calculate
(as you can guess, this cell SUMs two other cells)

Thanks for the help.