macro solver

[Guest]

I am using excel 2003 to record a macro with solver. I got problem. Please
help!

Here is what I did:
1. I started with "Tool" to "Macro" to "record new macro".I gave a name
"test" and "ok".
2. Then the solver part: I started with "Tool" to "solver". In the solver
manual, I chose the target and by changing cell and click "solve". I got the
estimates.
3. Then I stop the macro
4. Now in my macro "test", I have something like:
SolverOk SetCell:="$F$4", MaxMinVal:=2, ValueOf:="0", ByChange:="$E$4:$E$6"
SolverSolve

But I can not run this macro. The "test" is not doing what I want to do to
re-solve the problem.

Any suggestion will be appreciated.
Tony

 

[Kevin H. Stecyk]

Tony wrote...

I am using excel 2003 to record a macro with solver. I got problem. Please
help!

Here is what I did:
1. I started with "Tool" to "Macro" to "record new macro".I gave a name
"test" and "ok".
2. Then the solver part: I started with "Tool" to "solver". In the solver
manual, I chose the target and by changing cell and click "solve". I got
the
estimates.
3. Then I stop the macro
4. Now in my macro "test", I have something like:
SolverOk SetCell:="$F$4", MaxMinVal:=2, ValueOf:="0",
ByChange:="$E$4:$E$6"
SolverSolve

But I can not run this macro. The "test" is not doing what I want to do to
re-solve the problem.

Hi Tony,

Please provide the entire macro.

What happens as you single step through it. Does it do what you think it
should?

If not, where doesn't it work and why don't you think it works?

Regards,
Kevin