I'm trying to use solver in a macro and for some reason it won't find solutions when run from the macro. When I run it from the toolbar on the same cell it works perfectly.

I recorded the operation when I ran it manually to get the code for my macro. Here's what the recording came up with-

SolverReset
SolverOk SetCell:="$i$14", MaxMinVal:=2, ByChange:="$i$15"
SolverChange CellRef:="$i$14", Relation:=3, FormulaText:="$i$13"
SolverSolve

Like I said, when I run solver in the worksheet, it works and that's the code it records. When I run the macro it does not work. Can anyone help me understand what's going on here?

Thanks-