title: Excel VBA: .Range & Cells(row.count xlup
body: <p>I am trying to understand the following line:</p>
  
  <pre><code>.Range("A1:A" &amp; .Cells(.Rows.Count, "A").End(xlUp).Row).ClearContents
  </code></pre>
  
  <p>Can someone tell what <strong>.Range("A1:A" &amp;</strong>  means?</p>
  
  <p>From my research so far I found the following:</p>
  
  <ol>
  <li><strong>Cells</strong>      refers to the cells </li>
  <li><strong>.Rows.Count</strong> is a function that returns the number of rows in the table (=65536)</li>
  <li><strong>, "A"</strong> refers to the  column you want to search (here A) </li>
  <li><strong>.End</strong> tells EXCEL where to start</li>
  <li><strong>xlUp</strong> the direction to which EXCEL should search </li>
  <li><strong>.Row</strong> the first cell from the bottom that is not empty</li>
  <li><strong>.ClearContents</strong> deletes all values</li>
  </ol>
  
  <p>Can someone tell if this is corrrect, and overall explain what the entire line is trying to do?</p>
  
  <p>Assuming there may be values later added to column A, but I only wanted to delete the contents of 6 cells (A50:A55) how would I change this?</p>