<div>
Try this.<br />

<pre><code id="code-20-38327603-1">Range(Range(&quot;A1&quot;), Range(&quot;A1&quot;).End(xlDown).End(xlToRight)).Select</code></pre>
Note, in Excel VBA you rarely, if ever, need to select something.
</div>


Try this.


Range(Range("A1"), Range("A1").End(xlDown).End(xlToRight)).Select

Note, in Excel VBA you rarely, if ever, need to select something.

<div>
Thanks. I need to not select the last row. I want to select the whole range except the last row of the range.
</div>


Thanks. I need to not select the last row. I want to select the whole range except the last row of the range.

<div>
<div class="content wysiwyg-content">
Hi. I tried recording a macro with relative references turned on. <br />
I want to select a range that could have a varying number of rows except for the last row. I got the code attached but it has the references B46 which would not work if there were a different number of row. Anyone know what change to make?<br />
Thank you.<br />

<pre><code id="code-8252999">Sub Macro2()
'
' Macro2 Macro
'

'
    Range(&quot;A1&quot;).Select
    Range(Selection, Selection.End(xlToRight)).Select
    Range(Selection, Selection.End(xlDown)).Select
    Range(&quot;A1:B46&quot;).Select
End Sub</code></pre>
</div>
</div>


Hi. I tried recording a macro with relative references turned on. 
I want to select a range that could have a varying number of rows except for the last row. I got the code attached but it has the references B46 which would not work if there were a different number of row. Anyone know what change to make?
Thank you.


macro to select range

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