Solver - macro combination

I think I maybe barking up the the wrong tree...
I have problem that takes hours to optimize using solver.
(5 large data sets fit to 4 equations - using least squares.
I wrote a macro to determine the SS of the fit error ( in hopes of speeding things up a bit.)
My target cell is a function that calls the error fitting subroutine.and returns the SS error
I pass all the parameters (cells) I want to change through the macro so it recalculates automatically

The macro works fine, the subroutine works.
When I use solver I get value# in the target cell.
I'm using Excel 2000 - is there a work around or am I trying to do something that is outside of solvers capability?

Thanks in advance,
Gregg
.

Relevant Pages

  • Interacting with EXCEL Solver via macro
    ... I want to create a macro that will invoke EXCEL's Solver. ... macros mostly by recording. ... But, then, since the number I will be setting the target cell to will ...
    (microsoft.public.excel.programming)
  • Re: optimisation tool for objective function macro
    ... Solver requires a target cell (which has the value of the objective ... I can define my objective function is through a macro. ... values of the changing cells (optimisation variables) and runs the ... Solver requires the target cell to contain a formula, ...
    (microsoft.public.excel.programming)
  • Re: Solver - macro combination
    ... My opinion is that Solver cannot do "least squares" problems very ... When values are squared near zero, Solver cannot track "why" values ... I am surprised your Solver program ran for "Hours" when the target cell had ... I pass all the parameters I want to change through the macro so it ...
    (microsoft.public.excel.programming)
  • Re: Solver macro
    ... notice that you can not point to a cell in the "Value of" box. ... It may be done this way to make sure that the Target cell is not a dependent ... > I am trying to write a macro that uses Solver. ...
    (microsoft.public.excel.programming)
  • 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)
Loading