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.

Patrick Molloy Wrote:
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




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