Results 1 to 6 of 6

Looping a solver function

Threaded View

bkr_15 Looping a solver function 10-30-2012, 04:12 PM
AlphaFrog Re: Looping a solver function 10-30-2012, 04:51 PM
Alf Re: Looping a solver function 10-30-2012, 05:10 PM
shg Re: Looping a solver function 10-30-2012, 05:54 PM
bkr_15 Re: Looping a solver function 10-30-2012, 06:37 PM
arlu1201 Re: Looping a solver function 10-31-2012, 02:25 AM
  1. #1
    Registered User
    Join Date
    10-30-2012
    Location
    Canada
    MS-Off Ver
    Excel 2010
    Posts
    2

    Looping a solver function

    I need to turn this macro into a loop

    SolverOk SetCell:="$P$2", MaxMinVal:=2, ValueOf:=0, ByChange:="$M$2:$O$2", _
            Engine:=1, EngineDesc:="GRG Nonlinear"
        SolverSolve
        SolverOk SetCell:="$P$3", MaxMinVal:=2, ValueOf:=0, ByChange:="$M$3:$O$3", _
            Engine:=1, EngineDesc:="GRG Nonlinear"
        SolverSolve
        SolverOk SetCell:="$P$4", MaxMinVal:=2, ValueOf:=0, ByChange:="$M$4:$O$4", _
            Engine:=1, EngineDesc:="GRG Nonlinear"
        SolverSolve
    How might i be bale to do that ?

    Moderator's Edit: You need to use code tags whenever you post code in a post. You can either select the code and click on the # button above or type [code] before your code and [/code] after it.
    Last edited by arlu1201; 10-31-2012 at 02:25 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1