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?

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?