PC Review Forums Newsgroups Microsoft Excel Microsoft Excel Crashes Excel crashes after running solver

Reply

Excel crashes after running solver

 
Thread Tools Rate Thread
Old 31-01-2008, 12:16 AM   #1
folajinadu
Junior Member
 
Join Date: Jan 2008
Posts: 2
Trader Rating: (0)
Default Excel crashes after running solver


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
folajinadu is offline   Reply With Quote
Reply



Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off