Goal Seeking to a Cell instead of a hard number
 

I am trying to goal seek to a specific cell. Is it possible to do so without
typing in a hard number?

Goal Seeking to a Cell instead of a hard number
 

Nate.

You would need to use code:

Sub NateGoalSeek()
Range("A3").GoalSeek Goal:=Range("A2").Value, ChangingCell:=Range("A1")
End Sub

In this example, we are seeking to set the value returned by the formula in cell A3 equal to the
value entered in cell A2 by changing cell A1 (all of the activesheet).

HTH,
Bernie
MS Excel MVP


"nate" wrote in message
...
I am trying to goal seek to a specific cell. Is it possible to do so without
typing in a hard number?