Is this what you are looking for?

SolverReset

SolverOk _
SetCell:=Range("G14"), _
MaxMinVal:=1, _
ByChange:=Range("G9:I9")

'...etc


Not sure, but for Jonathan's idea, I believe "SolverSave" and "SolverLoad"
are one method of saving/loading Solver options.
HTH.

--
Dana DeLouis
Using Windows XP & Office XP
= = = = = = = = = = = = = = = = =


"Verlero" wrote in message
...
No, I am not saying that. Let me explain it again

I want to write a macro for running solver. The problem is
that each time you run it the Solver window in Excel is
saving the constraints (adding again the arguments in the
constraint window). I need to add an argument in order to
Reset all before seting the target, changing, and
constraint arguments.

Does this help as explanation?

Thanks for your answer

Velero


-----Original Message-----
"Velero" wrote in
news:11fec01c3f64f$e46772e0
:

I would like to know how to creat a macro for Resetill
all
the Solver options, before assinging parameters and run
it. The follwing example, taken from the microsoft
website, illustrates whatïs going on. The macro runs
okay,
but each time is saving the constraints on the window.
I
presume it must be added an argument to reset all
before.

Are you saying that you want the macro to note what the
existing options
are for Solver, save them somewhere, and restore them to
the solver dialog
box after it completes?

I don't think that's possible.