+ Reply to Thread
Results 1 to 3 of 3

Excel Solver issue

  1. #1
    Registered User
    Join Date
    02-16-2011
    Location
    US,US
    MS-Off Ver
    Excel 2007
    Posts
    8

    Excel Solver issue

    I'm trying to write some code for my solver but for some reason when I write the code below, I keep getting a "step into Prompt" which I've enclosed in a word document. I can't seem to disable this prompt, any help will be greatly appreciated and thank you for all your help in the past.

    Sub SOLVER()
    '
    ' Solver Macro
    '
    Application.DisplayAlerts = False
    Application.Run "Solver.XLAM!SolverReset"
    SolverReset
    Application.Run "SolverOk", "$C$7", 3, "30", "$C$3"
    SolverSolve userFinish:=True
    SolverFinish
    ''SolverOk SetCell:="$G$7", MaxMinVal:=3, ValueOf:="32", ByChange:="$G$3"
    'SolverSolve True
    Application.DisplayAlerts = True

    End Sub
    Attached Files Attached Files
    Last edited by vbhal; 04-04-2011 at 11:18 AM.

  2. #2
    Registered User
    Join Date
    02-11-2011
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2013
    Posts
    98

    Re: Excel Solver issue

    do you have the solver referenced?

    under tools...References...select solver

  3. #3
    Registered User
    Join Date
    02-16-2011
    Location
    US,US
    MS-Off Ver
    Excel 2007
    Posts
    8

    Re: Excel Solver issue

    Yes I did. Thanks but I just decided to sidestep the issue and use goal seek. Now it's all working. Thanks again!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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