Excel crashes after running solver

Joined
Jan 31, 2008
Messages
2
Reaction score
0
I have a routine that calls a solver function on each iteration. The results is Ok but after am done running my model, if I try to edit a cell using F2 excel crashes. Can someone tell me what the problem is? Thanks.

Public Sub NPV

Application.ScreenUpdating = False
Worksheets(strSHEETNAME_PricingModel).Activate
SolverOk SetCell:=Worksheets(strSHEETNAME_PricingModel).Range("NPV").Value, MaxMinVal:=3, ValueOf:="0", _
ByChange:=Worksheets("PricingModel").Range(BreakevenSpread).Value
SolverSolve UserFinish:=True

End Sub
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top