<div>
Do you mean:<br />
<br />

<pre><code id="code-20-40486750-1">range(cells(1,1),cells(50,16)).Select</code></pre>
?
</div>


Do you mean:



range(cells(1,1),cells(50,16)).Select

?

<div>
This will select everything from column A to P from row 1 down to the last row in column P.<br />

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


This will select everything from column A to P from row 1 down to the last row in column P.


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

<div>
<div class="content wysiwyg-content">
can an expert help me out here.<br />
<br />
I need to select a range that includes blank cells.<br />
<br />
i.e. The range I need to select is from A to P and could be A1 to P10 or A1 to P50 &nbsp;etc<br />
<br />
within that range there are sometimes blank columns i.e. column F, column I, column K , Column L but sometimes these columns will have data.<br />
<br />
Can you provide VBA that will select this sort of range please.
</div>
</div>


can an expert help me out here.

I need to select a range that includes blank cells.

i.e. The range I need to select is from A to P and could be A1 to P10 or A1 to P50  etc

within that range there are sometimes blank columns i.e. column F, column I, column K , Column L but sometimes these columns will have data.

Can you provide VBA that will select this sort of range please.

select a range that may include blank cells

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