Hi. I'm not too sure of the question.
My experience is that Solver is usually pretty good at determining if
your model is Linear. Did you want to set AssumeLinear to False?
If you think your model is Linear, and you want to keep it that way,
there is a chance your model is poorly scaled.
Try setting Scaling:=True

= = =
HTH
Dana DeLouis


Lone wrote:
I used macro to run the solver, but in some conditions, it come out a
different solversolve msg for the first time.

eg. when i run the first time, the solversolve msg come out "7", which means
"The conditions for Assume Linear Model are not satisfied", but the result is
correct. Once I repeat the solver, it returns 0. I have tried a few times,
but it come out same result.

Since I use the solversolve result to give a msg to user the result is ok or
not. Hope anyone can help.

//
SolverOptions MaxTime:=500, Iterations:=1000, Precision:=0.000001,
AssumeLinear _
:=True, StepThru:=False, Estimates:=1, Derivatives:=1,
SearchOption:=1, _
IntTolerance:=5, Scaling:=False, Convergence:=0.0001,
AssumeNonNeg:=True



SolverOk SetCell:="$F$6", MaxMinVal:=1, ValueOf:="0",
ByChange:=Range(Cells(8, 12), Cells(8, Icol))
result = SolverSolve(True)
//