Need Help with creating a Sorting Macro

[clm_cabot]

I want to use a macro to sort when the number of selected rows change. Here is my code for sorting. How do I change it so it will work only on the rows I select? So for example, in my code below I selected A9:D17 but this changes throughout the worksheet in sections that need sorting. Is this possible to do with a macro? Thanks.

Please Login or Register  to view this content.

[Cofad]

Can you attach a workbook?

[clm_cabot]

I have tried to attach a sample workbook. Basically my workbook is a summary of names and codes per all US states, sorting by Columns D,C,B. But since there is a space in my worksheet between every state, I need to highlight each section and pick my sorting columns every time. I want to create a macro to shorten the process by not having to sort each section every time. Each section has a different amount of rows and values every month. Thanks.

[jindon]

Try

Please Login or Register  to view this content.

[Cofad]

Try this:

Please Login or Register  to view this content.

As long as only one of the cells in the region you want to sort is selected the macro will sort that region based on the D, C, and B columns. If more than one cell is selected an error will throw. There must be a blank row between sections for the macro to sort each section independently. In addition. there needs to be a blank row between the header row and the first row of data.

HTH

[clm_cabot]

SOLVED: Thank you "Cofad". That works and saves me a lot of time. Thank you so much.