title: VBA: Paste named range as value
body: <p>I have a dynamic named range, call it "MYRange" in worksheet "Data1". By dynamic I mean that the range is coded as</p>
  
  <pre><code>=offset(A1,0,0, COUNTA(A:A),1). 
  </code></pre>
  
  <p>The actual values that populate these cells are done via a vlookup. I want to copy this range into another workbook called "Data2" as values, otherwise I get a reference issue.</p>
  
  <p>Thanks!</p>