View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Velero Velero is offline
external usenet poster
 
Posts: 4
Default Macro for Solver

I wrote a macro in VBA for running solver. The problem is
that each time I run it, the Solver window in Excel is
saving the constraints (adding again the arguments in the
constraint window). I think I need to add an argument in
order to Reset all the solver parameters before setting
the target, changing, and
constraint arguments. Any help on that?

Thanks in advance

Velero