I am having the same problem - no SetCell and ByChange values. Did you ever
get this resolved?

Thanks

"karamelmu" wrote:


When I run my code the 'Subject to the constraints' gets filled fine,
but for some reson 'Set Target Cell' and 'By Chaning Cells' remain
blank. Any idea what might be causing the problem -- could it be some
bug in Windows 2000? Thanks

~~~~~
Sub Program()

SolverOk SetCell:=Range("A1"), MaxMinVal:=1, ValueOf:="0",
ByChange:=Range("B1:B10") ' this is the stuff that gets omitted

SolverAdd CellRef:=Range("e2"), Relation:=2,
FormulaText:=Range("C1")
SolverAdd CellRef:=Range("B1:B10"), Relation:=1,
FormulaText:=1
SolverAdd CellRef:=Range("B1:B10"), Relation:=3,
FormulaText:=0

SolverSolve Userfinish:=True

End Sub


--
karamelmu
------------------------------------------------------------------------
karamelmu's Profile: http://www.excelforum.com/member.php...o&userid=15573
View this thread: http://www.excelforum.com/showthread...hreadid=271337