wz72n01
10-21-2007, 08:40 AM
I get this message: Sub or Function Not Defined
Sub Eff0()
'to return an efficient portfolio for given target return
SolverReset
Call SolverAdd(Range("portret1"), 2, Range("target1"))
Call SolverOk(Range("portsd1"), 2, 0, Range("change1"))
Call SolverSolve(True)
SolverFinish
End Sub
When I go to Tools and References in the VBA screen to select Solver, I cannot!!! The 'References..." is grayed out.
How do I get it to call solver? Thanks
Sub Eff0()
'to return an efficient portfolio for given target return
SolverReset
Call SolverAdd(Range("portret1"), 2, Range("target1"))
Call SolverOk(Range("portsd1"), 2, 0, Range("change1"))
Call SolverSolve(True)
SolverFinish
End Sub
When I go to Tools and References in the VBA screen to select Solver, I cannot!!! The 'References..." is grayed out.
How do I get it to call solver? Thanks