title: Goal seek macro, changing cell reference not a hard value
body: <p>I am trying to make a goal seek macro for my excel model. Is it possible to create a macro that the <code>ChangingCell</code> is not a hard value but an equal formula that refers to a hard value. </p>
  
  <pre><code>Range("D1").GoalSeek Goal:=0.17, ChangingCell:=Range("D424")
  </code></pre>
  
  <p>So in this case cell D424 would be = to another cell that has a hard value in it. The reason why I can set the <code>ChangingCell</code> directly to D424 is that the goal seek reference for the changing cell changes based on various selections on the file. </p>