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