title: Goalseek with VBA using a Value in a named cell as goal value
body: <p>Hi I'm trying to build a goalseek in VBA using a value from a named cell as the target value. I used the following source code and it does not work.
  Can you please help me?</p>
  
  <p>Thanks!</p>
  
  <pre><code>Worksheets("Assumptions &amp; Results").Range("EIRRHybrid").GoalSeek Goal:=Worksheets("Assumptions &amp; Results").Range("TargetEIRR").Value, ChangingCell:=Worksheets("Assumptions &amp; Results").Range("Revenues_for_PV")
  </code></pre>