+ Reply to Thread
Results 1 to 2 of 2

Solver mistakenly producing "Solver stopped by user" error

  1. #1
    Registered User
    Join Date
    09-17-2019
    Location
    Cary, NC
    MS-Off Ver
    Office 365
    Posts
    1

    Question Solver mistakenly producing "Solver stopped by user" error

    Hello,

    I am working on a fairly complex macro that employs Solver, but I noticed that it would often skip over certain parts of my data. Upon further analysis, I noticed that it was producing a "Solver stopped at user's request" message when it skipped these rows in question. I can confirm that there is absolutely no way that the escape or break keys were being pressed during the macro's run, even going so far as to add "Application.EnableCancelKey = xLDisabled" to that part of the macro. Curiously, I could run the exact same solver setup without the macro on the same rows of data and it would work without issue. Does anyone know what circumstances can cause Solver to mistakenly believe that it was stopped by the user? I've included the code of my Solver setup below.


    Please Login or Register  to view this content.

  2. #2
    Forum Expert Alf's Avatar
    Join Date
    03-13-2004
    Location
    Gothenburg/Mullsjoe, Sweden
    MS-Off Ver
    Excel 2019 and not sure I like it
    Posts
    4,758

    Re: Solver mistakenly producing "Solver stopped by user" error

    Hi

    Could you upload the file as well? Don't forget to remove sensitive data first.

    Aif

    Ps The paperclip for uploading don't work so you have to scroll down and click on the line "Manage Attachment"

+ 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. Replies: 0
    Last Post: 09-22-2015, 06:09 PM
  2. [SOLVED] SOLVER "error in model" error from VBA
    By tmallin in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 03-13-2014, 03:04 PM
  3. Replies: 11
    Last Post: 10-30-2013, 02:11 PM
  4. Macro for "adding" solver "constraints"?
    By hansaaa in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-21-2013, 02:58 PM
  5. [SOLVED] Using "SOLVER" to match two columns, but how to copy it for multiple rows ??? (URGENT)
    By hshahad in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-16-2013, 11:31 AM
  6. Using VBA to create a variable "adjustable cells" array in Solver
    By Kybynn in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-04-2012, 12:25 AM
  7. Excel solver should allow "equal to" value to be a selected cell.
    By Brantlee in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-19-2006, 02:55 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