Thread: solver
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
mike allen[_2_] mike allen[_2_] is offline
external usenet poster
 
Posts: 85
Default 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