Solver Macro functionality after Upgrade

BigBlueExceler

New Member
Joined
Aug 27, 2014
Messages
1
Hi All,

First forum post. Former Excel 2010 user, upgraded to 2013 standalone. Had a Solver macro & button built in to a file and now when I open in Excel 2013, running the macro does nothing. I'm sure its a simple fix, but I'm blanking. I doubt its code related, but just in case:
Code:
 Sub IRR_CASH_REQUIRED()
'
' IRR_CASH_REQUIRED Macro
'
    Range("M21").Select
        SolverOk SetCell:="$R$26", MaxMinVal:=3, ValueOf:=0, ByChange:="$C$16", Engine _
        :=1, EngineDesc:="GRG Nonlinear"
    SolverSolve (True)
End Sub
 

Some videos you may like

Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.

Watch MrExcel Video

Forum statistics

Threads
1,109,027
Messages
5,526,329
Members
409,696
Latest member
EERS

This Week's Hot Topics

Top