title: VBA Find a last row within a range?
body: <p>I want to find a last row with data within a range. for example i want to find a last empty row in range("A15:A42"). it should not go beyond A42. Any help.</p>
  
  <pre><code>lRow = Range("C15:C42").End(xlDown).Row   ....it goes beyond C42..
  </code></pre>
  
  <p><strong>IMP Info copied from comments</strong></p>
  
  <blockquote>
    <p>yes ..i will have some other data from C43 ... –  user2703472 3 hours ago </p>
  </blockquote>