<div>
Expect you start in column B<br />
<br />

<pre><code id="code-20-40030862-1">Range(Selection, Selection.End(xlDown)).Select
Range(Selection, Selection.Offset(0, 5)).Select</code></pre>
</div>


Expect you start in column B



Range(Selection, Selection.End(xlDown)).Select
Range(Selection, Selection.Offset(0, 5)).Select

<div>
<div class="content wysiwyg-content">
Range(Selection, Selection.End(xlDown)).Sel<wbr />ect<br />
&nbsp; &nbsp; Range(Selection, Selection.End(xlToRight)).<wbr />Select<br />
<br />
The above vba code will paint the range I need to copy. &nbsp;However, I only want columns B:G instead of the &quot;End(xlToRight).<br />
<br />
How do I modify the above to paint all the row with data and columns B:G?<br />
<br />
Thanks<br />
<br />
Glen
</div>
</div>


Range(Selection, Selection.End(xlDown)).Select
    Range(Selection, Selection.End(xlToRight)).Select

The above vba code will paint the range I need to copy.  However, I only want columns B:G instead of the "End(xlToRight).

How do I modify the above to paint all the row with data and columns B:G?

Thanks

Glen

Excel VBA - Specify a specific column range to copy

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