Undefined subject

[tweety]

Hi,

I have a problem with the "SolverReset" Command.
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
Everytime I run the Macro, it told me that "sub or function not defined". But I have checked the Answer and I tried to run it, it also encounters such a problem. Do I make any mistakes?[/code]

 

[dk]

Hi,

VBA doesn't know what SolverReset is - you need to tell it by clicking Tools, References and choosing Solver in the list.

Alternatively, if you don't want to set a reference you can use this line of code:-

Application.Run "Solver.xla!SolverReset"