Quotation Marks within Quotation Marks

Why are you duplicating threads with essentially the same question. With 91 posts you should know better.

Your other post has been closed.

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.

Hi Richard,

I'm not sure why you closed my other thread as this isn't a duplicate. My other thread related to data not sorting correctly with my custom sort. This thread was a question I had about how to use quotation marks in code so I thought they were different subjects? Forgive me if I'm wrong - I'm a vba novice and pretty new to this forum/not a frequent user.

Your reply here actually relates to my other post really. My data wasn't in fact sorting correctly. As shown in the image attached to that post, the data was almost identical (same Brand, Gender, SKU) except from the Size and as Size is the last thing to be sorted it should appear in the order laid out in my custom sort. Rorya was able to fix this problem for me with his reply and it works as expected now.

I'm not entirely sure what you mean about the keys thing - I'm pretty new to VBA and have just followed instructions from various website etc. But thank you for your help. Problem solved

Your other thread and this one both mentioned that the sort was not what you expected, and they both referenced the same bit of code procedure.

I think it reasonable to assume that those who are already familiar with your first request are more than likely to be able to chip in with any addition to your request and you are therefore better served by keeping everything together.