Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: solver in macro

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I want to make a macro that uses the excel solver, is this possible? and if its possible how do you do it, i always keep getting errors.

    [ This Message was edited by: kristofvdz on 2002-03-28 14:55 ]

  2. #2
    MrExcel MVP Joe Was's Avatar
    Join Date
    Feb 2002
    Location
    Central Florida, USA
    Posts
    7,539
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default

    You do the equivalent of Tools-Solver with the VBA clip:

    SolverOK setCell:=Range("AA6"),maxMinVal:=1, byChange:=Range("B8:C11")

    Where the trick is "SolverOK" which is the same as Tools-Solver. Note: you need to set the options and you will need additional Solver methods and properties.

    The Solver.xla must be installed for these codes to work. JSW

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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