Writing a macro that updates solver solutions?
I want to write a macro that will update several cells that are calculated
using the solver function. So far, the only way I've found to do this is to
update them one-by-one which is very tedious. So I'm trying to write a macro
that will do this easily. I tried recording the macro and doing it manually,
which gave me the following code:
SolverOk SetCell:="$F$32", MaxMinVal:=3, ValueOf:="100", ByChange:="$A$32"
SolverSolve
Unfortunately, when I try to run the macro, it says that the SolverOk
function is not a valid function. So I'm not sure what I can do to fix this.
Any help is greatly appreciated.
|