|Excel Developer Reference|
Calculates the values necessary to achieve a specific goal. If the goal is an amount returned by a formula, this calculates a value that, when supplied to your formula, causes the formula to return the number you want. Returns True if the goal seek is successful.
expression A variable that represents a Range object.
|Goal||Required||Variant||The value you want returned in this cell.|
|ChangingCell||Required||Range||Specifies which cell should be changed to achieve the target value.|
This example assumes that Sheet1 has a cell named "Polynomial" that contains the formula =(X^3)+(3*X^2)+6 and another cell named "X" that’s empty. The example finds a value for X so that Polynomial contains the value 15.
|Visual Basic for Applications|