+ Reply to Thread
Results 1 to 2 of 2

Solver Looping

  1. #1
    Registered User
    Join Date
    05-10-2014
    MS-Off Ver
    Excel 2003
    Posts
    1

    Solver Looping

    I am trying to repeat solver a few hundred times. I'm very inexperienced with writing macros and would greatly appreciate if someone could help me write this one.

    SolverOk SetCell:="$C$6", MaxMinVal:=1, ValueOf:=0, ByChange:="$C$6,$D$6,$F$6" _
    , Engine:=1, EngineDesc:="GRG Nonlinear"
    SolverOk SetCell:="$C$6", MaxMinVal:=1, ValueOf:=0, ByChange:="$C$6,$D$6,$F$6" _
    , Engine:=1, EngineDesc:="GRG Nonlinear"
    SolverSolve
    Attached Files Attached Files

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Solver Looping

    The target cell can't be one of the changing cells. Maybe something like this:

    Please Login or Register  to view this content.
    Please take a few minutes to read the forum rules, and then edit your post to add CODE tags.
    Last edited by shg; 05-10-2014 at 07:33 PM.
    Entia non sunt multiplicanda sine necessitate

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Looping a solver function
    By bkr_15 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-31-2012, 02:25 AM
  2. Solver and Looping for a range
    By ziad9933 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-18-2012, 11:19 AM
  3. looping of Solver in VBA
    By bored in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 09-14-2010, 11:28 AM
  4. Looping and Solver
    By junejaja in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-28-2008, 11:53 AM
  5. Looping a Solver
    By Peter1999 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-31-2007, 08:32 AM

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