title: use specific cell value as address for next action
body: <p>I've been messing and searching for a while, but am not capable enough.</p>
  
  <ul>
  <li>I want to select a range from <code>L7</code> to where the value in the cell is 'Anchorsec' (also column L). </li>
  <li>You can apparently sort of do it like this, and <code>EndCell</code> does contain the value <em>AnchorSec</em>, but how do i use  cell address of <code>EndCell</code>? </li>
  </ul>
  
  <p><em>code</em></p>
  
  <pre><code>Dim EndCell As Range
  
  Set EndCell = ActiveSheet.Range("L7:L30").Find("AnchorSec", LookIn:=xlValues)
  ActiveSheet.Range("L7:EndCell.Adress").Copy
  ActiveSheet.Range("K7:EndCell.Address.Offset(0, -1)").Paste
  </code></pre>