| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
vba goal seek 2
Please ignore the post. The following seems to work fine, didn't know why it wasn't working yesterday. I might have missed a couple of inputs within the row or the goal seek just wasn't converging. Thanks all! Method 1: For i = 19 To 27 Cells(i, "AE").GoalSeek Goal:=Cells(i, "AD"), ChangingCell:=Cells(i, "AF") Cells(i, "AZ").GoalSeek Goal:=Cells(i, "O"), ChangingCell:=Cells(i, "BA") Next i -- csw78 ------------------------------------------------------------------------ csw78's Profile: http://www.excelforum.com/member.php...o&userid=23008 View this thread: http://www.excelforum.com/showthread...hreadid=378345 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to use goal seek | Excel Worksheet Functions | |||
| goal seek | Excel Discussion (Misc queries) | |||
| Goal Seek | Excel Discussion (Misc queries) | |||
| Goal Seek | Excel Worksheet Functions | |||
| Goal Seek (in VBA) | Excel Programming | |||
![csw78[_4_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
