M
meinfs
The code below often causes "out of memory or resources
exhausted" error messages.
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!
exhausted" error messages.
ByChange:="$B$7" <SolverOk SetCell:="$L$7", MaxMinVal:=2, ValueOf:="0",
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!