title: Solver in VBA does not add the integer constraint
body: <p>I was using VBA code to run solver. Below is my code. I want cells C87:K93 to be integers, however, the constraint does not get added into Solver so the values I get are all decimals. May I know how I can change the code so that the integer constraint get taken into account?</p>
  
  <pre><code>Sub Solve()
     SolverReset
     SolverAdd CellRef:="$C$87:$K$93", Relation:=4, FormulaText:="integer"
     SolverAdd CellRef:="$C$87:$K$93", Relation:=1, FormulaText:="$C$48:$K$54"
     SolverAdd CellRef:="$L$87:$L$93", Relation:=1, FormulaText:="$M$87:$M$93"
     SolverAdd CellRef:="$C$87:$K$93", Relation:=3, FormulaText:="0"
  
     SolverOk SetCell:="$N$95", MaxMinVal:=1, ValueOf:="0", ByChange:="$C$87:$K$93"
     SolverSolve UserFinish:=True
  End Sub
  </code></pre>
  
  <p>Below is the link to the picture of Solver after running the code, the integer constraint just doesn't appear </p>
  
  <p><img src="https://i.stack.imgur.com/zPMQK.jpg" alt="Picture"></p>
  
  <p>Thanks so much for helping</p>