VBA "sub or function not defined"

Jul 26, 2011
Reaction score
Hi I am trying to use solver from VBA, however when I execute my code I get the following message: "sub or function not defined"

Any help would be welcomed in resolving this problem. Below is my solver code in VBA.

''**Solver Calculations**

'Resets solver, allowing it to be clear when used next

'MAD is minimised by changing the Weights
SolverOk SetCell:="MAD", MaxMinVal:=2, ValueOf:="0", ByChange:="Weights"

'Portfolio Mean is greater than or equal to the expected return
SolverAdd CellRef:="PortfolioMean", Relation:=3, FormulaText:="d"

'Sum of Weights has to equal 1
SolverAdd CellRef:="$C$129", Relation:=2, FormulaText:="1"

'Assume non-negativity
SolverOptions AssumeNonNeg:=True

'Repeats the first constraint
SolverOk SetCell:="MAD", MaxMinVal:=2, ValueOf:="0", ByChange:="Weights"

'Ensures the results dialogue box does not appear
SolverSolve UserFinish:=False

'Solves the solver

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question