including solver in a Macro

  • Thread starter Thread starter Scot
  • Start date Start date
S

Scot

I am working on creating a macro that will identify cells to be used in the
solver as the "target cell" and the "by changing cell" boxes. I also need
it to pick up a figure in the "equal to value" box from a specific cell in
the spreadsheet. Once these are defined, it needs to begin the solving
process. When it is done, go on with the rest of the macro.

I hope this makes sense.

Thanks,

Scot
 
Scot,

A good starting point is often to record a macro doing the solver with your
parameters, and look at the resulting code.

Earl Kiosterud
mvpearl omitthisword at verizon period net
 
Back
Top