excel - Automatic Calculation Turned Off by VBA Macro -


this more of curiousity urgency: have following code repeated several times in larger macro. finding if specify search method (by including "engine:=..") macro turns off automatic calculation (found in formulas>calculation options) , switches manual. fixes optimsation @ single point, though below optimisation on loop optimises different values. cells linked each other not update because of problem renders optimisation useless. can run macro without specifying search method ideally able choose it. ideas?

solverreset     solverok setcell:="$k$21", maxminval:=1, valueof:="0", bychange:="$d$41:$h$41", engine:=2     solveradd cellref:="$k$25", relation:=2, formulatext:="1"     solveradd cellref:="$d$41:$h$41", relation:=3, formulatext:="0"     solveradd cellref:="$d$41:$h$41", relation:=3, formulatext:="$d$12:$h$12"     solveradd cellref:="$d$41:$h$41", relation:=1, formulatext:="$d$13:$h$13"                         solversolve userfinish:=true                         solverfinish keepfinal:=1                         range("k23").value = range("k21").value 


Popular posts from this blog

Php - Delimiter must not be alphanumeric or backslash -

Delphi interface implements -

java - How to create Table using Apache PDFBox -