Excel VBA: .Range & Cells(row.count xlup
<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>