Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2006
    Posts
    47

    Unanswered: using solver addin via vba

    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

  2. #2
    Join Date
    Apr 2006
    Posts
    47
    silly me, although the macro recorded it, there was no reference to solver i had to add it

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •