|Excel Developer Reference|
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|