Set Target cell is not behaving

  • Thread starter Thread starter meinfs
  • Start date Start date
M

meinfs

The code below often causes "out of memory or resources
exhausted" error messages.
SolverOk SetCell:="$L$7", MaxMinVal:=2, ValueOf:="0",
ByChange:="$B$7" <

But when I go back and look at the Menu => Tools =>
solver, the solver seems to have forgotten the VB line
above and I have to manually reclick to 'Set Target Cell
to $L$7, Equal to 0' and then click Close. (and I
usually leave ByChange to blank).

This works and the macro is back on its merry way.

Why does the VB code appear to not work correctly? Any
tips to recode it so that I don't have to do it manually?

Thanks!
 
I forgot to mention that I
click on "Min" as the Maxminval in the graphical version
of solver.
 
Back
Top