When I run my code the 'Subject to the constraints' gets filled fine
but for some reson 'Set Target Cell' and 'By Chaning Cells' remai
blank. Any idea what might be causing the problem -- could it be som
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 Su

--
karamelm
-----------------------------------------------------------------------
karamelmu's Profile: http://www.excelforum.com/member.php...fo&userid=1557
View this thread: http://www.excelforum.com/showthread.php?threadid=27133