tomcatt014
New Member
- Joined
- May 9, 2011
- Messages
- 1
Im trying to create a Macro is Excel 2010 that runs the solver that solves for an IRR based on a sale price. The IRR formula calculates correctly and the solver works if I run it manually. Whan I tried to record the macro I received an error message that read "Compile Error Can't find project or library" . Cell references below:
F264: IRR
E262: Sale Price
Code
Sub Solva()
'
' Solva Macro
'
'
SolverOk SetCell:="$F$264", MaxMinVal:=3, ValueOf:=0.1, ByChange:="$E$262", _
Engine:=1, EngineDesc:="GRG Nonlinear"
SolverOk SetCell:="$F$264", MaxMinVal:=3, ValueOf:=0.1, ByChange:="$E$262", _
Engine:=1, EngineDesc:="GRG Nonlinear"
SolverSolve
End Sub
F264: IRR
E262: Sale Price
Code
Sub Solva()
'
' Solva Macro
'
'
SolverOk SetCell:="$F$264", MaxMinVal:=3, ValueOf:=0.1, ByChange:="$E$262", _
Engine:=1, EngineDesc:="GRG Nonlinear"
SolverOk SetCell:="$F$264", MaxMinVal:=3, ValueOf:=0.1, ByChange:="$E$262", _
Engine:=1, EngineDesc:="GRG Nonlinear"
SolverSolve
End Sub