I am trying to write a macro to sort data with a variable range. As data is added, a new row is created with the first column being a date and I want to sort by date.

What I want it to do is go to the first row and first column of the data and then go to the end row of the data and go over a fixed number of columns. It is trying to adjust the number of rows that I am unable to get.