solver
i recorded a macro while using the solver function, which worked, but when i
tried to re-use the code that it had recorded, it said "sub or function not
defined" and highlighted "SolverOk"
sub test()
SolverOk SetCell:="$G$1", MaxMinVal:=3, ValueOf:=".0124", ByChange:="$G$2"
SolverSolve
end sub
any thoughts? thanks, mike allen
|