Set Target cell is not behaving

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!
 
M

Meinfs

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top