i am working on calc the annuity amout given the npv and the only way to get it (that i know of) is to use the solver addin. I recorded using the addin macro, but when i try to run the vba i get a message Sub or function not defined. here is the vba my macro recorded:



SolverOk SetCell:="$b$4", MaxMinVal:=3, ValueOf:="50000", ByChange:="$b$5"
SolverSolve

silly me, although the macro recorded it, there was no reference to solver i had to add it