how to write a macro for solver function

[ernestgoh]

hi, i need to write a macro that calls the solver function.

the solver is used to find the price that gives me a target profi
margin of 15% for a range of ages 1 to 10.

appreciate if anyone can help or share. thanks alot

 

[davidm]

Earnest,

Provide more details of your layout. What are your Target cell,
Changing Cell?Make sure the target cell contains a formula!

David

 

[Patrick Molloy]

turn on the macro recorder, run solver, turn off the recrder and examoine th
ecode that was generated. It will give you pretty much all you need.

 

[ernestgoh]

i have using the marco recorder. it still doesnt solve the problem. i
have to manually hit enter on a pop up base after the solver finds a
solution.