VBA to select a data set - not hard code it

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

Try

Range("A1").CurrentRegion.Sort

That's perfect!


Thank you!

Originally Posted by mrice

Try

Range("A1").CurrentRegion.Sort

'column A is always filled in
Range("A1:E" & Range("A" & Rows.Count).End(xlUp).Row).Sort

I believe the current region isn't updated until the workbook is saved. Could be wrong off course.

Charlize