Closed Thread
Results 1 to 2 of 2

Trying to Run Solver multiple times

  1. #1
    Registered User
    Join Date
    04-24-2017
    Location
    Russellville,Arkansas
    MS-Off Ver
    2013
    Posts
    2

    Trying to Run Solver multiple times

    I am trying to create a code that will allow me to run solver multiple times. I am trying to solve a duopoly question that by changing the quantities of Firm 1 & Firm 2 it will create the maximum condition. The quantities of both firms should be the same. The answer is 80 for both firms, now i just need to find a code that will get me that answer. I am going to include the excel spreadsheet so that you may see what I am trying to find out. I am new to VBA and I have no idea what to do. Any help would be appreciated. Thanks!
    Attached Files Attached Files

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2404 Win 11 Home 64 Bit
    Posts
    23,865

    Re: Trying to Run Solver multiple times

    This is a second warning. You have posted this request twice in the open forum and once in the Commercial Services Area. Once you post in the Commercial Services, we close all posts of the same issue in the Open Forum. Continued posting of this nature may result in infractions against your profile and or banishment for ignoring moderator requests. This thread is closed. You may continue in the Commercial Services area.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. How to Run Solver Multiple Times
    By cmcgough in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-24-2017, 04:41 PM
  2. Replies: 1
    Last Post: 04-27-2016, 03:05 PM
  3. Creating a Macro That will Run Solver Multiple Times
    By Otaishtf in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-27-2013, 10:28 AM
  4. Run Solver Multiple Times (while changing constraints and goal for each iteration)
    By pmw1218 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-03-2013, 04:17 PM
  5. Using Solver Multiple Times In One Sheet
    By g1362901 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-12-2009, 09:02 AM
  6. [SOLVED] Using Excel Solver multiple times with macros
    By Barry T in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-09-2005, 04:06 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