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" wrote:


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 profit
margin of 15% for a range of ages 1 to 10.

appreciate if anyone can help or share. thanks alot.


--
ernestgoh
------------------------------------------------------------------------
ernestgoh's Profile: http://www.excelforum.com/member.php...o&userid=24870
View this thread: http://www.excelforum.com/showthread...hreadid=475272