title: Resize Range in VBA
body: <p>I am trying to resize a range by looking down the rows of a column for the next used value, however I am getting an object defined error. Any ideas?</p>
  
  <pre><code>Set vrng = ActiveSheet.Range("details_table").Find(sest, , xlValues, xlWhole)
  Set vrng = vrng.Resize(vrng.End(xlDown).Row)
  </code></pre>