Hello!
I have put together some VBA code to custom sort some data (below). However, I'm getting unexpected results and I don't know why.
Screenshot 2019-04-11 at 10.49.53.png
Please Login or Register to view this content.
In my custom sort, UK sizes should appear in ascending order (UK 4, UK 6, UK 8, UK 10, UK 12, UK 14). However, as you can see from the image, they don't appear in this order.
Is anyone able to help me figure this out? I have attached my workbook for reference.
Thank you!
The data is sorting correctly. The Size is the last key to be sorted. Maybe you should sort by Size before by SKU, or even earlier depending on the precise order.
But I question why you are adding sort keys every time with the macro. In fact every time you run the macro you just add another set of sort keys which repeat the first set. This is wasteful of resources.
Why can't you manually sort the data as you want and then just have the macro perform the sort without any of the .AddKey stuff.
If you do want to add keys for some strange reason then at least have the macro first delete what's there.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Your sort list didn't actually match your data properly, and you should clear the existing sort before adding new fields, so:
Please Login or Register to view this content.
Everyone who confuses correlation and causation ends up dead.
Why are you duplicating threads. WIth 91 posts you should know better. This post will now be closed and you should continue in your other thread.
Thread Closed.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks