How do I switch off recalculation when using Solver in VBA?
<p>I tried to use Solver on a working sheet, say sheet A. I also have some cells with "=rand()" on sheet A, or say any formula on the sheet using custom functions with <code>Application.Volatile</code> written inside. I'd like these volatile cells to stop recalculate when I am doing solver, so I used <code>Application.Calculation = xlCalculationManual</code> in my Solver program, but turned out after I ran the Solver, I found that those volatile cells have changed. Where have I done wrong?</p>