Using custom sort orders with Range().sort

**WestWindsDemon** · 08-21-2018, 01:48 PM

Good day everyone. I'm looking for a way to use a custom sort order with a Range().Sort method. I've seen some other ways to use custom sort orders but quite honestly I don't understand a lot of them. I've been trying with following bit of code to no avail, it defaults the order to alphabetical:

Please Login or Register  to view this content.

The goal of this code was to pull the custom sort order from the [Property Get]. I'm still a noob at VBA, any help either understanding or making this work would be appreciated. Thanks!

**Leith Ross** · 08-21-2018, 03:17 PM

Hello WestWindsDemon,

Your use of the Property Get indicates the code in a Class Module. Can you post either all of the module code or a sample workbook?

**WestWindsDemon** · 08-21-2018, 03:52 PM

I just scratched the property get part. I'm trying to focus solely on getting a custom sort order. While messing around with my code I did a sort by row and messed up my whole worksheet. I'm trying to fix that mistake now. And I didn't know property get should be on a class module. I've been using it on normal modules. The main issue that I'm having is getting that [OrderCustom:=] to properly work; honestly I have no idea what or how to put anything there.

Using custom sort orders with Range().sort

LinkBack

Thread Tools

Rate This Thread

Display

Using custom sort orders with Range().sort

Re: Using custom sort orders with Range().sort

Re: Using custom sort orders with Range().sort

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Custom sort the same range on every workseet except the first sheet?

Challenged: ascending sort within custom sort

[SOLVED] Macro to select a data range then apply a custom sort

Shortcuts to different sort orders?

[SOLVED] How to use custom sort while sorting left to right for entire dynamic used range

selecting range for custom sort

Excel sort by Fill Color by custom list sort

Bookmarks

Bookmarks

Posting Permissions