On May 26, 5:44 pm, "Jon Peltier"
wrote:
Your line was missing some quotes:
SolverOk SetCell:="$DV$4", MaxMinVal:="2", ValueOf:="1",
ByChange:="$DU$4"
Off the top of my head, I don't know whether they are needed around the
numerical values.

I've had a little experience with Crystal Ball and with another package,
@Risk ("at risk") by Palisade. My experience is that the Palisade product
interfaces more smoothly with Excel. You should at least look at both.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. -http://PeltierTech.com
_______

"Jasper" wrote in message

...

"....The model solution value is your SetCell. So you have that defined.
The
ByChange value is supposed to be the range of decision variables. If
you are only defining a single cell as a single decision variable,
there's not much of a problem..."

There's the crux, the code works fine, though for some reason the result
will not show in the designated place after the macro is done. Though I
ran
out of things that could be wrong about this code.

SolverReset
SolverOk SetCell:="$DV$4, MaxMinVal:=2, ValueOf:=1", ByChange:="$DU$4"
SolverSolve UserFinish:=True
SolverFinish KeepFinal:=1

Thanks so far, I'm looking into Chrystal Ball. Gr.

Jasper

Jasper,

I agree with Jon. Crystal Ball does better marketing, but @Risk is a
better product. And Palisade just released version 5 of their
decision tools suite. So you can try that out simultaneously while
solving your problem.

SteveM