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

Please Login or Register  to view this content.

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

That's perfect!


Thank you!

Originally Posted by mrice

Try

Please Login or Register  to view this content.

Please Login or Register  to view this content.

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

Charlize