Re: Using the addin solver inside a macro

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Tom Ogilvy (twogilvy_at_msn.com)
Date: 09/17/04 

Date: Fri, 17 Sep 2004 16:08:31 -0400

The question was answered. Can't you see the answer? 

-- 
Regards,
Tom Ogilvy
"TerryM" <tmcgrew@new.rr.com> wrote in message
news:52d2b3da.0409170925.7ed79463@posting.google.com...
> When I record a macro using the solver addin and try to run the macro
> the error "Sub or Function not defined" results.  The solver works
> because I can run it manually.  Is there any way to run the solver
> from inside a macro?
>
> TerryM

Relevant Pages

  • Re: Solver programming questions
    ... Recording a macro usually works. ... This allows you make sure you do not have any constraints that you are not aware of. ... Creating a macro by recording the use of Solver did not pickup the constraint statements. ... First problem is that the solver runs successfully on the first occasion the ...
    (microsoft.public.excel.programming)
  • Re: Solver programming questions
    ... "Dana DeLouis" wrote: ... Recording a macro usually works. ... This allows you make sure you do not have any constraints that you are ... recording the use of Solver did not pickup the constraint statements. ...
    (microsoft.public.excel.programming)
  • Re: Solver Function - Making it Automatic
    ... "Scenario" for Scenario Manager, and then put the Scenario Manager button on ... Solver doesn't work well with data spread out on other sheets. ... the macro I recorded performs about 16 "solver" ... spreadsheets that I don't particularly want to "see". ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Solver programming questions
    ... Thanks Dana, I omitted to put C1 in exclamation marks so that part works fine ... Can you help me code constraints in the macro please? ... recording the use of Solver did not pickup the constraint statements. ...
    (microsoft.public.excel.programming)
  • Re: Solver Function - Making it Automatic
    ... I'm having some problems still with the Macro thing. ... basically just "started recording a macro", performed the solver task (i.e. ... Once you've performed all the steps, stop recording. ... Solver to find the constant repayment figures neccessary to give the required ...
    (microsoft.public.excel.worksheet.functions)