PC Review
Forums
Newsgroups
Microsoft Excel
Microsoft Excel Crashes
Excel crashes after running solver
Forums
Newsgroups
Microsoft Excel
Microsoft Excel Crashes
Excel crashes after running solver
![]() |
Excel crashes after running solver |
|
|
Thread Tools | Rate Thread |
|
|
#1 |
|
Junior Member
|
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 |
|
|
|
![]() |
|
| Thread Tools | |
| Rate This Thread | |
|
|

Main Page 

