title: EPPlus, Find and set the value for a Named Range
body: <p>I've been pulling my hair out trying to set the value of a named range (in this case, a single named cell) using the ExcelPackage (3.0.1) library, it should be a simple as this:</p>
  
  <pre><code>ExcelNamedRange er = xlPackage.Workbook.Names["Customer"];
  er.Value = "Foo Bar";
  </code></pre>
  
  <p>I'm obviously doing it wrong - has anyone got an example I can follow</p>
  
  <p>Thanks</p>