I want to create a macro to stop me having to Data>Sort and select four columns in order every time. So it allows me to sort a highlighted range, by multiple columns. The two issues I have are:
I cant control and down to the last row, because there will be blanks in the data.
The range will change size and locations a lot, hence why I'm highlighting the data.
Part of my code for example:
ActiveWorkbook.Worksheets("Sheet2").Sort.SortFields.Add Key:=Range("F14:F21") _, SortOn:=xlSortOnValues, Order:=xlAscending, DataOption:=xlSortNormal
May include Row 17 as a blank so I cant control down, and the next set of data to sort could be B3:B10. I can always highlight the range, but I cant get VBA to sort that highlighted range.
All help welcomed!