| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to write a macro for solver function
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 -- ernestgo ----------------------------------------------------------------------- ernestgoh's Profile: http://www.excelforum.com/member.php...fo&userid=2487 View this thread: http://www.excelforum.com/showthread.php?threadid=47527 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how to write a macro for solver function
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how to write a macro for solver function
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how to write a macro for solver function
Earnest, Provide more details of your layout. What are your Target cell, Changing Cell?Make sure the target cell contains a formula! David -- davidm ------------------------------------------------------------------------ davidm's Profile: http://www.excelforum.com/member.php...o&userid=20645 View this thread: http://www.excelforum.com/showthread...hreadid=475272 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I write a Macro into an IF Function? | Excel Discussion (Misc queries) | |||
| How do I write an Excel Macro to run Solver repeatedly? | Excel Programming | |||
| is it possible to execute write to the fields in another .xsl form a macro in another .xsl? e.g. some way to load another .xsl into an .xsl macro and write to its data? | Excel Worksheet Functions | |||
| Solver Record Macro Function | Excel Programming | |||
| Calling up the Solver function in a VBA macro | Excel Programming | |||
![ernestgoh[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
