Goal Seeking to a Cell instead of a hard number

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to goal seek to a specific cell. Is it possible to do so without
typing in 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
 
Back
Top