+ Reply to Thread
Results 1 to 2 of 2

Solver - Showing all solutions

  1. #1
    Registered User
    Join Date
    12-04-2008
    Location
    USA
    Posts
    1

    Question Solver - Showing all solutions

    I am looking to use the Solver utility but want to present the end user with all possible solutions, not just one. In at least Excel 2003/7 there is an option to "Show Iteration Results". In VBA this sets the StepThru:=True. The problem is that it gives the user a prompt for every solution. I want to capture each possible solution in an array, or even write it back to the workbook in another location so that when the Solver completes I can present the user with all the solutions.

    Has anyone encountered this before or have any advice?

  2. #2
    Forum Contributor mewingkitty's Avatar
    Join Date
    09-29-2008
    Location
    Fort McMurray, Alberta, Canada
    MS-Off Ver
    Excel 2003
    Posts
    949

    Uh

    I think I saw something about that
    http://www.eggheadcafe.com/software/...bers-from.aspx
    here.

+ Reply to Thread

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