<div>
Just to clarify. I will always use Range(&quot;A1&quot;).CurrentRegion.<wbr />Select<br />
<br />
the region may be from A1 to Z100 one day and A1 to Z600 another etc
</div>


Just to clarify. I will always use Range("A1").CurrentRegion.Select

the region may be from A1 to Z100 one day and A1 to Z600 another etc

<div>
Exellent you always come up with a solution for me Thanks
</div>


Exellent you always come up with a solution for me Thanks

<div>
<div class="content wysiwyg-content">
I am using the below code to select a range. The range will change each time it is used.<br />
<br />
Range(&quot;A1&quot;).CurrentRegion.<wbr />Select<br />
<br />
I need to then be able to sort on column Z but not sure how to do this as the range changes.<br />
<br />
Can an expert help me out with this please.<br />
<br />
Thanks
</div>
</div>


I am using the below code to select a range. The range will change each time it is used.

Range("A1").CurrentRegion.Select

I need to then be able to sort on column Z but not sure how to do this as the range changes.

Can an expert help me out with this please.

Thanks

VBA to sort after select

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