I'm trying to automate weekly reports so I don't want my ranges to be hard coded the size of data sets will vary from week to week.

Although
Range("A1:E89").Sort
works fine for this week, next week may need ("A1:E95")

The data will always be in columns A:E but and there is no blank cells but the number of rows will vary.

Can anyone sugeest a piece of code that will select just the data set?

Thank to anyone who takes time to consider this