| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problems running Solver from VB: Windows 2000 users?
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Page breaks are different in Windows 2000 and Windows XP | Excel Discussion (Misc queries) | |||
| problems switching speadsheets in excel 2000 using windows xp | Excel Discussion (Misc queries) | |||
| Excel Programs developed in Office 2000 on Windows 2000 | Excel Discussion (Misc queries) | |||
| Excel 2000 running on Windows XP SP2 does not properly open CSV fi | Excel Discussion (Misc queries) | |||
| Code-signing certificate problems in Excel 2000 with Windows 2000 | Excel Programming | |||
Threaded Mode
