I want to make a macro button that will sort on ranges that i have highlighted.

Hello,

I am trying to make a worksheet for people that aren't very familiar with Excel. I want to make a sort button that will sort only the areas that have been highlighted. There are multiple places where this worksheet will be sorted. I know that somehow I will have to change the range in my macro.

Please Login or Register  to view this content.

This is the macro now for an area I selected. Which range do I change to make it only highlighted areas.

Thanks