Solver macro slow when recalculate

A

Arno

Hi all,

I'm using the solver inside a simple macro to calculate a few cells in a
worksheet. When executed alone, this macro is fast (let's say
instantaneous).
What I'd like to do is to call this macro automatically everytime the sheet
is recalculated. I've tried this:

Private Sub Worksheet_Calculate()
Application.Calculation = xlCalculationManual
Solver_macro
Application.Calculation = xlCalculationAutomatic
End Sub

But the macro in this case is extremely slow ! I can't figure out what's the
problem.
Would you have a hint ? I only have a very limited knowledge in vba and
macros ...
Thanks a lot !
Arno
 
D

Dave Hawley

Hi Arno

Try

Private Sub Worksheet_Calculate()
Application.Calculation = xlCalculationManual
Application.EnableEvents = False
Solver_macro
Application.Calculation = xlCalculationAutomatic
Application.EnableEvents = True
End Sub


Posted via: http://www.ozgrid.com
Excel Templates Training Add-ins.
Free Excel Forum & Business Software
 
Top