Results 1 to 8 of 8

Using Solver With Another Iterative Routine

Threaded View

  1. #1
    Registered User
    Join Date
    07-31-2008
    Location
    Australia
    Posts
    12

    Using Solver With Another Iterative Routine

    I've written an iterative numerical integration Sub which works fine. Several arguments are passed to it (cell references).

    I now wish to incorporate Solver in the code process so that it reads the integration result, changes the values of two of the argument cells, after which the integration routine runs again, Solver changes the cells again, etc, until the integral is minimised.

    Overall:

    1. Initial values are set up as the arguments.

    2. The integration routine then iteratively calculates the integral, based on the passed arguments.

    3. Solver reads the integration result, then changes two of the argument cells.

    4. Steps 2 and 3 repeat until Solver determines the integral result found at step 2 has been minimised.

    (The final values of the changing cells (arguments) are then used for other things.)

    I am unable to define the structure of the VBA code to achieve this.

    I call the integration Sub, then call Solver, but Solver does a single pass only.

    How do I get the integration sub and Solver to be repeatedly called, until the minimum integral value is found, after which the result is passed back to a cell, and the code terminates?
    Last edited by kubota1000; 08-20-2008 at 10:08 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Looping and Solver
    By junejaja in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-28-2008, 11:53 AM
  2. Solver Package and VBA Macros
    By junejaja in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-24-2008, 09:02 PM
  3. Excel Solver giving wrong optimal solution
    By gtg430i in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-11-2008, 02:29 PM
  4. Solver and Worksheet events
    By whuahu in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-30-2007, 09:38 AM
  5. SOLVER add-on problems
    By fl4sh in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-26-2007, 12:10 PM

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