title: VBA: SolverAdd Ignorning Constraints
body: <p>I'm trying to set up solver for each run of a macro but it seems to be ignoring some of the constraints but not all of them for some reason.</p>
  
  <pre><code>SolverReset
  SolverOk SetCell:="$N$15", MaxMinVal:=3, ValueOf:=0, ByChange:=Range("i3", Range("i3").End(xlDown)), _
  Engine:=3, EngineDesc:="Evolutionary"
  SolverAdd CellRef:=Range("k3", Range("k3").End(xlDown)), Relation:=1, FormulaText:="1"
  SolverAdd CellRef:="$P$12:$P$13", Relation:=1, FormulaText:="$R$12:$R$13"
  SolverAdd CellRef:="$P$12:$P$13", Relation:=3, FormulaText:="$N$12:$N$13"
  SolverAdd CellRef:=Range("n3", Range("n3").End(xlDown)), Relation:=2, FormulaText:="1"
  SolverAdd CellRef:=Range("i3", Range("i3").End(xlDown)), Relation:=5, FormulaText:="binary"
  SolverSolve
  </code></pre>
  
  <p>It is only ignoring the constraints for the ranges Range("n3", Range("n3").End(xlDown)) and Range("k3", Range("k3").End(xlDown))</p>
  
  <p>Any help would be appreciated. </p>
  
  <p>thanks!</p>