VBA code for Sort Ascending to specified area

Hello,

I'm struggling with figuring out how to sort an area in my sheet. I'm running several other macros before I need to complete the sort. Once I get to the sort, I have been struggling with it sorting correctly. It seems to keep sorting only a portion of my data and it's incorrect. I'm open to creating its own macro to embed in my larger macro, or just a few lines of code to add.

The number of rows varies, so I can't specify an exact number of rows, but I also need to sort Columns N through Y, using the Y Column as my key. Also, my data does not begin on Y1. I have a title in Y3 and then the data begins in Y4. So, realistically, I need to sort N4:Y(Undeteremined) with my titles in Row 3.

I hope this makes sense. I've attached a sample workbook in hopes that this gives an idea of what I'm trying to accomplish.

Your help is EXTREMELY appreciated.

Thanks in advance,

Tyler

Isn't it just

Please Login or Register  to view this content.

?

Hey jindon,

Thanks for the response, I really appreciate it.

I have tried a dozen different methods and canNOT figure it out, so I am grateful for your input.

That being said, I tried your line on the Example Book I provided and it worked great, however, when I plug it into my master file, the ranking is not in order!!? I don't understand.

This is the order that resulted once I plugged it into my actual workbook:

Total Rank
1
2
3
4
9
5
6
6
6
14
11
10

I have no clue how this is even possible. Any thoughts?

If the layouts and the data type are the same as workbook posted, it should sort properly, so something must be different.