Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
SolverParameters behaviour different in VBA and Excel?
When I define solver options in VBA i.e. step thrue:=true to get the intermediate calculation result during debugging the program, the solver solves without stop the equations. But if I stop the program in VBA Code with a breakpoint an
insert the same paramters in the Excel solver window and activate step thru, the calculation will stop after each iteration Does anyone knows the problem and how to solve it? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
SolverParameters behaviour different in VBA and Excel?
Don't know what to write. The code below worked as expected, i.e.,
Solver paused after each iteration. Maybe, you should post the code you are using. Option Explicit Sub Macro1() SolverReset SolverOptions MaxTime:=100, Iterations:=100, _ Precision:=0.000001, AssumeLinear:=False, _ StepThru:=True, Estimates:=1, Derivatives:=1, _ SearchOption:=1, _ IntTolerance:=5, Scaling:=False, _ Convergence:=0.0001, AssumeNonNeg:=False SolverOk SetCell:="$B$1", MaxMinVal:=2, ValueOf:="0", _ ByChange:="$A$1" SolverAdd _ CellRef:="$A$1", Relation:=3, FormulaText:="0""" SolverSolve End Sub -- Regards, Tushar Mehta, MS MVP -- Excel www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions In article , says... When I define solver options in VBA i.e. step thrue:=true to get the intermediate calculation result during debugging the program, the solver solves without stop the equations. But if I stop the program in VBA Code with a breakpoint and insert the same paramters in the Excel solver window and activate step thru, the calculation will stop after each iteration. Does anyone knows the problem and how to solve it? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Weird Excel diagram behaviour | Charts and Charting in Excel | |||
Very annoying behaviour of Excel 2003 | Excel Discussion (Misc queries) | |||
Help with odd Excel behaviour - Data Validation | Excel Discussion (Misc queries) | |||
strange behaviour in Excel 2003 when importing XML | Excel Discussion (Misc queries) | |||
Excel 2007 - Autofilter different behaviour | Excel Discussion (Misc queries) |