Set Target cell is not behaving
 

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!

Set Target cell is not behaving
 

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

-----Original Message-----

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?