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:
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