| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Goal Seek in a Macro
I am attampting to write a macro where I use goal seek to solve for price
based on the desired IRR input. When I bring up goal seek, it forces me to manually input a value, rather than allow me to reference a cell value as the input variable. Is there anyway to reference a cell value as the value I would like to solve for within my macro? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Goal Seek in a Macro
Yes. You can programatically change the cell that needs to be static to a
value and then change it back to a formula after you perform the goal seek. -- http://HelpExcel.com "mrogge2895" wrote: I am attampting to write a macro where I use goal seek to solve for price based on the desired IRR input. When I bring up goal seek, it forces me to manually input a value, rather than allow me to reference a cell value as the input variable. Is there anyway to reference a cell value as the value I would like to solve for within my macro? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Goal Seek | Excel Discussion (Misc queries) | |||
| How to use goal seek | Excel Worksheet Functions | |||
| using Goal Seek inside a recorded macro | Excel Worksheet Functions | |||
| Can I build 'goal seek' facility into a macro? | Excel Discussion (Misc queries) | |||
| Goal Seek tool in a macro | Excel Discussion (Misc queries) | |||
Hybrid Mode
