'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
true
if the goal seek is successful, false
otherwise.