'Declaration
 
Public Function GoalSeek( _
   ByVal variableSheet As Integer, _
   ByVal variableRow As Integer, _
   ByVal variableColumn As Integer, _
   ByVal formulaSheet As Integer, _
   ByVal formulaRow As Integer, _
   ByVal formulaColumn As Integer, _
   ByVal desiredResult As Double _
) As Boolean

'Usage
 
Dim instance As SpreadView
Dim variableSheet As Integer
Dim variableRow As Integer
Dim variableColumn As Integer
Dim formulaSheet As Integer
Dim formulaRow As Integer
Dim formulaColumn As Integer
Dim desiredResult As Double
Dim value As Boolean
 
value = instance.GoalSeek(variableSheet, variableRow, variableColumn, formulaSheet, formulaRow, formulaColumn, desiredResult)

public bool GoalSeek( 
   int variableSheet,
   int variableRow,
   int variableColumn,
   int formulaSheet,
   int formulaRow,
   int formulaColumn,
   double desiredResult
)

Parameters

variableSheet

Sheet index of cell that contains value to adjust

variableRow

Row index of cell that contains value to adjust

variableColumn

Column index of cell that contains value to adjust

formulaSheet

Sheet index of cell that contains formula

formulaRow

Row index of cell that contains formula

formulaColumn

Column index of cell that contains formula

desiredResult

Formula result you wish to achieve

Reference

SpreadView Class
SpreadView Members