Thanks again DRJ for solving my post on how to select and copy the next emtpy range. Since that post is marked solved I figured I would start a new thread. Since I have that, Is there any way to do this to select the last filled row in a range where the column's might be varying lengths?

Ex: Last filled row is row 6, Columns A:C

Next time macro is run the Last filled row is row 7, but Columns A:E

Any ideas on how to get this to extend to the last filled column in the last filled row? Not a big deal, just figured it would be a great value in the future.

Thanks,