Macro for Excel Solver

S

Sankar Das

I have created a worksheet for optimizing certain
function. I am using Excel Solver for this purpose. The
Target cell / Adjastable cells / Constraints are all
defined. The solver is used for optimizing after data is
changed periodically.

I want to record the steps of solver in a macro, so that
anyone can execute it, after inputing the data in right
place.

Can I record it in a macro? I tried to do it, but did not
work. Any suggestion?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top