Hi. Just off the top of my head, it sure doesn't sound like your new
constraint is a good idea. That constraint is taken care of in Solver's
"SolverOk ..." line.
Just throwing this out. Using ValueOf:=Range("B12").Value should work. Is
it pointing to the correct cell reference?
For your range names, how about doing this on a worksheet...Insert | Name |
Paste... | Paste List.
Then, make sure all your range names are spelled correctly, and all
reference the "Active" and "Correct" worksheet.
(Ie...In :=[MO_DCRMin]., make sure "O" is the correct form... Letter O or
Number 0. ) (I've never done that...:)
HTH
--
Dana DeLouis
Win XP & Office 2003


"Karl" wrote in message
ups.com...
Hei Dana,

thanks very much, I still do not know why it does not work. But I got
around the problem by adding a constraint for DCRAve to be the same
Value as DCRMin. The Solver usually gives a reply that he found an
unsatisfied solution which works, and with your help I could get rid of
the MSGBox (SolverSolve True).

Thank You,

Karl