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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Goal seek via macro? 1
Parameter Input for Goal Seek 2
Goal Seek in a Macro 1
Help understanding Goal Seek Calculation 3
goal seek function 3
Assign Function to a Command Button 1
Goal seek - Is there a bug? 2
Goal seek on more than one cell 1

Back
Top