Sort Macro

[Viking88]

I have multiple sections in a spreadsheet I want to sort, using a macro, such as (A28:I41), (A45:I58), etc. I want all the data sorted by column F in descending order.

Can I define a name to a section (A28:I41) in the macro in the event rows are inserted at a later date?

Thanks,
Ken

 

[Viking88]

Maybe I dodnt word this right.

What I need to do is be able to sort certain sections of a report, but I want to be able to account for any rows that will be inserted in the future.

Any ideas?