Reducing Solver Calculation

[zealousteedo]

i've create a VBA code that uses Solver several times to optimize four values on my spreadsheet (the location of the four values does not change). The solver only requires calculations on a certain number of rows (say 1-200), but changing the four variables will recalculate the entire spreadsheet (thousands of rows). Each time the solver is run, sequentially, the required section of row calculation moves down the spreadsheet.

Is there a way for solver to calculate ONLY the rows required for optimization, and leave the others untouched until they are needed during later optimizations? this would greatly speed up my macro.

Any help would be appreciated.

 

[zealousteedo]

bump

 

[shg]

Set calculation to manual before running the code?

 

[zealousteedo]

I've tried doing that, and it doesn't reduce calculation time, unfortunately.