Advertisement
Help Keep Boards Alive. Support us by going ad free today. See here: https://subscriptions.boards.ie/.
If we do not hit our goal we will be forced to close the site.

Current status: https://keepboardsalive.com/

Annual subs are best for most impact. If you are still undecided on going Ad Free - you can also donate using the Paypal Donate option. All contribution helps. Thank you.
https://www.boards.ie/group/1878-subscribers-forum

Private Group for paid up members of Boards.ie. Join the club.

Excel Macro + Solver addin

  • 03-03-2003 04:29PM
    #1
    byrnenj
    Closed Accounts Posts: 566 ✭✭✭


    Hi,

    i'm a little stuck in Excel.
    I'm trying to record a macro which uses the Solver Excel addin. I record the macro and end it but then when i try and run it, it says SolverOk is undefined.
    It writes a VB script for the macro but unfortunetly i don't know anything about VB.
    Can anybody help me out.

    Cheers!


Comments

  • #2
    byrnenj
    Closed Accounts Posts: 566 ✭✭✭byrnenj


    bump!


  • #3
    Earthhorse
    Registered Users, Registered Users 2 Posts: 14,722 ✭✭✭✭Earthhorse


    Um, I don't know much about solver but maybe if you post the code from the macro (use code tags) and tell us what version of Excel you're working off you might get a response.


  • #4
    RicardoSmith
    Closed Accounts Posts: 8,259 ✭✭✭RicardoSmith


    I don't get it. What are the solvers for? Could you not do what the solvers do in VBA?


Advertisement