View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Graham Whitehead Graham Whitehead is offline
external usenet poster
 
Posts: 72
Default Looping solver for recursive optimization

if you can attach an example sheet with some code i can take a look

wrote in message
oups.com...
Thanks for the quick reply. I added SolverFinish KeepFinal:=1 and
removed the additional Solver but I still get the same break.

Graham Whitehead wrote:
Hmm, dont know why you put the extra SOLVER at the beggining - but here
is
some code i used for much the same thing and it works fine for me.

'Solve but dont display results
SolverSolve userfinish:=True
'get result
SolverFinish KeepFinal:=1