Hello all,
I am trying to create a macro that autosorts two seperate ranges in the same worksheet with varying length. I did a test run using the "Record Macro" but the code is messy. So I am attempting to revamp the code and make it cleaner.
I have figured out how to highlight the seperate ranges but I am having difficulty doing sorting the "Rank" column in ascending order. Can someone help me please where i am going wrong.
I have attached the workbook with explanation.
Thank you very much.
I am trying to create a macro that autosorts two seperate ranges in the same worksheet with varying length. I did a test run using the "Record Macro" but the code is messy. So I am attempting to revamp the code and make it cleaner.
I have figured out how to highlight the seperate ranges but I am having difficulty doing sorting the "Rank" column in ascending order. Can someone help me please where i am going wrong.
I have attached the workbook with explanation.
Thank you very much.