| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Goal Seek in a loop
I have used the following to run a simple goalseek on one line. Range("AE3").Select Range("AE3").GoalSeek Goal:=0, ChangingCell:=Range("AA3") Is it possible to get this doen in a loop acting on every entry in column AE? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Goal Seek | Excel Discussion (Misc queries) | |||
| goal seek wont calculate an accurate value past 3 decimal places | Excel Discussion (Misc queries) | |||
| Goal Seek on Multiple Cells | Excel Worksheet Functions | |||
| Goal Seek - Why make the PV negative? | Excel Discussion (Misc queries) | |||
| Goal Seek - reference a cell for "To value" field? | Excel Worksheet Functions | |||
Threaded Mode
