including solver in a Macro

[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

 

[Earl Kiosterud]

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