'Declaration
 
Overloads Function GoalSeek( _
   ByVal goal As Double, _
   ByVal changingCell As CellReference, _
   Optional ByVal changeIfFound As Boolean _
) As Boolean

'Usage
 
Dim instance As IRange
Dim goal As Double
Dim changingCell As CellReference
Dim changeIfFound As Boolean
Dim value As Boolean
 
value = instance.GoalSeek(goal, changingCell, changeIfFound)

bool GoalSeek( 
   double goal,
   CellReference changingCell,
   bool changeIfFound
)

Parameters

goal

The value you want returned in this cell.

changingCell

Specifies which cell should be changed to achieve the target value.

changeIfFound

if set to true, the changingCell's value is changed only if the goal seek is successful.

Return Value

Reference

IRange Interface
IRange Members
Overload List