<div>
This one liner should select all of the data in coumn A from A1 to the last row of Data.<br />
<br />

<pre><code id="code-20-38333654-1">Range(&quot;A1&quot;, &quot;A&quot; &amp; Range(&quot;A&quot; &amp; Rows.Count).End(xlUp).Row).Select</code></pre>
</div>


This one liner should select all of the data in coumn A from A1 to the last row of Data.



Range("A1", "A" & Range("A" & Rows.Count).End(xlUp).Row).Select

<div>
Thanks. So would this be the recommended way to get to the cell just below that?
<pre><code id="code-8253018">    Range(&quot;A1&quot;).Select
    Range(&quot;A1&quot;, &quot;A&quot; &amp; Range(&quot;A&quot; &amp; Rows.Count).End(xlUp).Row).Select
    Selection.End(xlDown).Select
    ActiveCell.Offset(1, 0).Range(&quot;A1&quot;).Select</code></pre>
</div>


Thanks. So would this be the recommended way to get to the cell just below that?

    Range("A1").Select
    Range("A1", "A" & Range("A" & Rows.Count).End(xlUp).Row).Select
    Selection.End(xlDown).Select
    ActiveCell.Offset(1, 0).Range("A1").Select

<div>
<div class="content wysiwyg-content">
Hi folks. I want to select a range of cells that are in a column. I remember that there is a good way to do this in such a way that if there are some missing data in some cells, that I can still capture the whole set of data. What I have would not do that. Can someone tell me a good way?
<pre><code id="code-8253017">    Range(&quot;A1&quot;).Select
    Range(Selection, Selection.End(xlDown)).Select
    Selection.End(xlDown).Select
    ActiveCell.Offset(1, 0).Range(&quot;A1&quot;).Select</code></pre>
</div>
</div>


Hi folks. I want to select a range of cells that are in a column. I remember that there is a good way to do this in such a way that if there are some missing data in some cells, that I can still capture the whole set of data. What I have would not do that. Can someone tell me a good way?

select a set of data in a column

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.