| Home |
| Search |
| Today's Posts |
|
#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 |
| 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[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
