ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   VBA Sort method w/more than 3 Keys (https://www.excelbanter.com/excel-discussion-misc-queries/42584-vba-sort-method-w-more-than-3-keys.html)

KenRoy

VBA Sort method w/more than 3 Keys
 
How can I sort a worksheet in VBA on more than 3 columns?

Dave Peterson

Same way as manually.

Sort multiple times.

Sort by the 3 most minor columns first, then the next 3 most minor, ..., until
you get to the 3 most major.



KenRoy wrote:

How can I sort a worksheet in VBA on more than 3 columns?


--

Dave Peterson


All times are GMT +1. The time now is 11:53 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com