VBA range and selection

I used record macro to figure out how to make vba sort but it wont let the range be the selected area. This will be a problem when the user adds or removes rows so I need vba to sort values in a range given that the number of rows could change

Column AI is a Match function that finds the first date that work begins and then sorting that column makes the whole chart flow